- Reading triggering table data in trigger (without error SQL0746N)
Hello,I'm looking for a DB2 workaround on a topic already solved in Oracle:the problem of mutating tables (which states that a trigger actioncannot read the triggering table's data). Yes, I know the trivialanswer: "just pass the triggering table's data as parameters to thestored p...
- Reading triggering table data in trigger (without error SQL0746N)
Hello,I'm looking for a DB2 workaround on a topic already solved in Oracle:the problem of mutating tables (which states that a trigger actioncannot read the triggering table's data). Yes, I know the trivialanswer: "just pass the triggering table's data as parameters to thestored p...
- Reading Tables & Columns
Hello,I'm not familar with DB2 under AS400. I want to read, which tables are in a database and which columns are in a selected table. Under DB2 for LUW I use the views SYSIBM.TABLES and SYSIBM.COLUMNS. Are these elements the same under DB2 for AS400?Thanks for helpBest Regards...
- Reading GRAPHIC datatype with db2 connect
Hi,SW environment :DB2/AS400 version 5.2DB2 Connect version 7.2I am trying to read data from a table (file) where the field is defined with the graphic datatype. The table is defined like thiscreate table pbtest(f1 GRAPHIC(5) CCSID 13488 DEFAULT NULL ) ; When trying to read data (select f1 from...
- Reading Event Monitor Outputs
Started an event monitor and it was writing to file. The files were created automatically as 00000016.evt. How can I read these files.Thanks in advance...
- Reading ASC files in DB2 UDB - Urgent
Hi All,I am using DB2 UDB 8.1 on linux platform.I want to import or read .asc file from DB2 stored procedure. This filecontains encryption and decryption key in multiple lines. I havefollowing problem when i use load command or import commandWhen I use load or import utility then these separate...