Let me try again[my second post on the subject]
I wrote an update/insert trigger to do contextual analysis on data piped into sql7 through a powerBuilder program. The source of data is EBCDIC/DB2/OS390 Mainframe(aka yucky) and the purpose of the trigger is to do 1-byte-to-2-bytes conversion of CHAR data in some columns.
The trigger is only successful when commiting after each row and using a cursor through INSERTED...
Can I do it commiting more than a row at a time and without the use of cursors?
Instead of triggers, we tried the using vbscript in a DTS (using DB2 connectivity drivers such as Starsql 32/IBM db2 connect odbc/ms oledb ), but all failed due probably to the nature of the query. the query is a beast made up of more than 9 unions and hundreds of lines of sql code.
Much obliged ..
I wrote an update/insert trigger to do contextual analysis on data piped into sql7 through a powerBuilder program. The source of data is EBCDIC/DB2/OS390 Mainframe(aka yucky) and the purpose of the trigger is to do 1-byte-to-2-bytes conversion of CHAR data in some columns.
The trigger is only successful when commiting after each row and using a cursor through INSERTED...
Can I do it commiting more than a row at a time and without the use of cursors?
Instead of triggers, we tried the using vbscript in a DTS (using DB2 connectivity drivers such as Starsql 32/IBM db2 connect odbc/ms oledb ), but all failed due probably to the nature of the query. the query is a beast made up of more than 9 unions and hundreds of lines of sql code.
Much obliged ..