Since you are using DBQuery to extract data from a database, it would make more sense to use the DB Adaptor for running the map instead of extracting the data and then sending it using the "TEXT" function using the echo adaptor.
This way when the map executes, it would directly extract the data...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.