- Log for ODBC/OCI version of the process
D2000 DBManager
10:06:42.678 19.07 Db TENTO.MesDB con 3:PG_READ BEG
10:06:42.678 19.07 ReadPage (Direction: 5): SELECT "ID_MATERIAL","GROUP","NAME","RANK","VALIDITY","TIME" FROM "CPIS"."MATERIAL" WHERE VALIDITY = 1 OR VALIDITY = 0 ORDER BY ID_MATERIAL
10:06:42.688 19.07 ReadPage time displayed in pure UTC (configured offset +2)
10:06:42.689 19.07 ReadPage data row 1: 2; 1; 'Name2'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.689 19.07 ReadPage data row 2: 3; 1; 'Name3'; 'S3'; BTRUE; 2006-05-05 03:06:07.891;
10:06:42.690 19.07 ReadPage data row 3: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.691 19.07 ReadPage data row 4: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.694 19.07 ReadPage end
10:06:42.694 19.07 Db TENTO.MesDB con 3:PG_READ END
10:06:43.761 19.07 Db TENTO.MesDB con 3:PG_INSERT BEG
10:06:43.762 19.07 PositionedInsert: INSERT INTO "CPIS"."MATERIAL" (ID_MATERIAL,ID_GROUP,NAMe,RANK,VALIDITY,TIME) VALUES (?,?,?,?,?,?)
10:06:43.763 19.07 PositionedInsert time displayed in pure UTC (configured offset +2)
10:06:43.763 19.07 PositionedInsert data: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:43.774 19.07 PositionedInsert end
10:06:43.775 19.07 Db TENTO.MesDB, con 3:PG_INSERT END
Note:
red lines - information of the DBG.DBMANAGER category
blue lines -information of the DBG.DBMANAGER.DATA category
- Log for the OCI version of the process
D2000 DBManager
10:06:42.678 19.07 Db TENTO.MesDB con 3:PG_READ BEG
10:06:42.678 19.07 ReadPage (Direction: 5): SELECT ROWID,"ID_MATERIAL","ID_GROUP","NAME","RANK","VALIDITY","TIME" FROM "CPIS"."MATERIAL" WHERE VALIDITY = 1 OR VALIDITY = 0 ORDER BY ID_MATERIAL
10:06:42.688 19.07 ReadPage time displayed in pure UTC (configured offset +2)
10:06:42.689 19.07 ReadPage data row 1,ROWID=AAAKy5AAUAAAAAuAAB: 2; 1; 'Name2'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.689 19.07 ReadPage data row 2,ROWID=AAAKy5AAUAAAAAuAAC: 3; 1; 'Name3'; 'S3'; BTRUE; 2006-05-05 03:06:07.891;
10:06:42.690 19.07 ReadPage data row 3,ROWID=AAAKy5AAUAAAAAtAAB: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.691 19.07 ReadPage data row 4,ROWID=AAAKy5AAUAAAAAtAAE: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.694 19.07 ReadPage end
10:06:42.694 19.07 Db TENTO.MesDB con 3:PG_READ END
10:06:43.761 19.07 Db TENTO.MesDB con 3:PG_INSERT BEG
10:06:43.762 19.07 PositionedInsert: INSERT INTO "SKVI"."MATERIAL" (ID_MATERIAL,ID_GROUP,NAME,RANK,VALIDITY,TIME) VALUES (:1,:2,:3,:4,:5,:7)
10:06:43.763 19.07 PositionedInsert time displayed in pure UTC (configured offset +2)
10:06:43.763 19.07 PositionedInsert data: 5; 5; 'xxx'; 'Rank2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:43.774 19.07 PositionedInsert end
10:06:43.775 19.07 Db TENTO.MesDB con 3:PG_INSERT END
Note:
red lines - information of the DBG.DBMANAGER category
blue lines -information of the DBG.DBMANAGER.DATA category
Related pages:
Pridať komentár