1. 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

     
  2. 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:

Napíšte komentár