Hi,
I need to run a SQL script on a DB2 database on AS400. I prepared an easymorph that loads the sql script (each row a sql command) and iterate on each command calling the runsql module:
The runsql module runs the sql contained into the input parameter:
Everything works fine (insert/update commands worked because I can see the changes inside the fields) but no existing trigger on the table is fired up (causing troubles).
Does the component "Database command" uses some parameters or the connection has to contain some parameter in order to have the triggers triggered the way they work anytime I run the same script in DBeaver for example?
Thanks, Marco
Hi @Marco_Ferraresi,
I case with AS400, "Database command" just executed SQL commands through the AS400 ODBC driver. With some of ODBC drivers it's possible to override the settings from the used ODBC DNS by specifying custom properties in the EasyMorph's ODBC connector settings. But EasyMorph doesn't override those settings on it's own.
Does DBeaver uses the same ODBC DSN as EasyMorph? If so, please post a screenshot of connection settings from DBeaver.
DBeaver uses JDBC drivers provided by DBeaver itself.
Here are the default properties used by DBeaver:
ODBC Driver settings:
I've seen it's possible to add custom properties in the Easymorph connector... maybe one of the reported above can help on ODBC.
@Marco_Ferraresi, thank you for the screenshots.
Can you please try to add all the libraries, involved in the queries and mentioned in the trigger, to the "Library list" option of you ODBC DSN. Will that make the triggers work?
1 Like
Thank you so much Andrew, it works!
I've added the list of my libraries included the KLDDAM where triggers are defined and now it works properly. Incredible & dangerous.
1 Like
