Database trigger mechanism

[alpesh0111]

Hi All,

I have version 6.7 on and oracle db. I want to trigger a map using the database trigger. However I also want to know that which operation on the database caused the map to be triggered.

for e.g. If there has been an insert in a database table, then a flag should be set to insert. If the table was updated then the flag should be set to update.

thanks
alpesh

 

[BocaBurger]

Yes. All information you require is in the documentation.
If Oracle 8i, make sure you have 8.1.7.4.1 or later client, known issue with previous that will cause core dumps or gpf (depending on patform). Suggest upgrade to 6.7.1 or better yet, 7.5.1


BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[alpesh0111]

Hello BocaBurger,

I have created the map and the system file to be triggered on the event in the database table.
However the solution that I am trying to acheive is as follows:
1. In the case of an table insert. I need to do update that same entry in a lookup table (file).
2. In the case of a table update. I need to update the same lookup table (file) with the updates happened in the database.
3. In the case of a row being deleted from the table. I need to remove the row from the lookup table (file).

my question are as follows :
1. Is there a way by which I can check due to which event in the db table the map execution was triggered?
2. If not then, is creating individual maps for each type of db event is the only option ?

Cheers
Alpesh Makwana

 

[BocaBurger]

Best way would be to use separate maps. Depending on how busy the DB is, this could also keep the system load for one map down.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!