- Zápis pre ODBC/OCI verziu procesu
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","ID_SKUPINA","NAZOV","SARZA","PLATNOST","CAS" FROM "SKVI"."MATERIAL" WHERE PLATNOST = 1 OR PLATNOST = 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; 'Nazov2'; 'Sarza2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.689 19.07 ReadPage data row 2: 3; 1; 'Nazov3'; 'S3'; BTRUE; 2006-05-05 03:06:07.891;
10:06:42.690 19.07 ReadPage data row 3: 5; 5; 'xxx'; 'Sarza2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.691 19.07 ReadPage data row 4: 5; 5; 'xxx'; 'Sarza2'; 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_SKUPINA,NAZOV,SARZA,PLATNOST,CAS) 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'; 'Sarza2'; 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
Poznámka:
červené riadky - informácie kategórie DBG.DBMANAGER
modré riadky - informácie kategórie DBG.DBMANAGER.DATA
- Zápis pre OCI verziu procesu
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_SKUPINA","NAZOV","SARZA","PLATNOST","CAS" FROM "SKVI"."MATERIAL" WHERE PLATNOST = 1 OR PLATNOST = 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; 'Nazov2'; 'Sarza2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.689 19.07 ReadPage data row 2,ROWID=AAAKy5AAUAAAAAuAAC: 3; 1; 'Nazov3'; 'S3'; BTRUE; 2006-05-05 03:06:07.891;
10:06:42.690 19.07 ReadPage data row 3,ROWID=AAAKy5AAUAAAAAtAAB: 5; 5; 'xxx'; 'Sarza2'; BTRUE; 2002-01-31 23:00:00.000;
10:06:42.691 19.07 ReadPage data row 4,ROWID=AAAKy5AAUAAAAAtAAE: 5; 5; 'xxx'; 'Sarza2'; 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_SKUPINA,NAZOV,SARZA,PLATNOST,CAS) 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'; 'Sarza2'; 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
Poznámka:
červené riadky - informácie kategórie DBG.DBMANAGER
modré riadky - informácie kategórie DBG.DBMANAGER.DATA
Súvisiace stránky:
Pridať komentár