Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
Resolution:
It is because trigger statements use semicolons to delimit multiple SQL statements within it. We arbitrary chose the # character as the SQL statement terminator. In this situation, you must set the SQL terminator to the # character before you run the scripts. In SPUFI, you can set it in one of the panels. In DSNTEP2 or DSNTIAD utilities, you can code PARMS (‘SQLTERM(#)’) in the RUN command. For other venue, consult the respective manuals.