UPDATE Trigger WITHOUT cursor

[sguslan]

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/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?

Much obliged ..

 

[jjonesal]

Are you running DB2 on MVS, VSE, or on an AS/400? If you are running on MVS, there is a driver that will allow you to use a DB2 datasource with DTS. (StarSQL 32 versions 2.52.0501 is what BOL says). I would think you would be able to make this transformation a lot easier using a DTS package.... Unless there's some business reason you need to go through PB.... J. Jones
jjones@cybrtyme.com

 

[sguslan]

Yes sir ...I am referring to OS390/DB2 V7.2...
When we upgrade from sql7 to sql2000 we will use dts instead. But for now, with sql7 and DTS, all db2 connectivity drivers that we tried have some sort of problems[ including STARSQL32/IBM DB2 Connect ODBC/MS OLEDB-ODBC]...
Mind you the query we run on DB2 to collect data is a complicated beast comprised of 12 UNIONs and hundreds of SQL lines...thanx to stupid programming practices.....