Hi, Can somebody tell me what the following SAP DB ODBC trace means and what the warnings are for? The program that I ran does not work as expected. Regards, Ajit
PRODUCT : SAP DB C-PreComp Runtime VERSION : 7.3.0 BUILD : 028-000-000-000 DATASOURCE: mmp SESSION : 1; SQLMODE : INTERN SERVERDB : mmp SERVERNODE: localhost CONNECT "NUANCE " IDENTIFIED BY :A ISOLATION LEVEL 0 START : DATE : 2002-10-31 TIME : 0010:52:32 END : DATE : 2002-10-31 TIME : 0010:52:32 STMMODE : ORACLE SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ? PARSE : CMD : mfIndex init : 1 mfIndex init : 2 PARSEID: OUTPUT: 0000182A 00000201 3C002E00 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ? EXECUTE: CMD : PARSEID: INPUT : 0000182A 00000201 3C002E00 01000000 WARNING: W1-------------- INPUT : 1: COLUMN1 : 1 [four lines of binary data here] mfIndex init : 2 mfIndex init : 2 WARNING: W1-------------- SQLRESULTNAME : SQL_CURSOR_0002 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE MASS STATEMENT : FETCH "SQL_CURSOR_0002" PARSE : CMD : WARNING: W--3------------ PARSEID: OUTPUT: 0000182A 00000401 2A002B00 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE MASS STATEMENT : FETCH "SQL_CURSOR_0002" EXECUTE: CMD : PARSEID: INPUT : 0000182A 00000401 2A002B00 01000000 PARAMETER DESCRIPTION: 0X014CB518 Application Kernel Nr. Type Length Type Length Fraction --------------------------------------------- 1 7 13 0 10 0 OUTPUT : 1: EXPRESSION1 : 0 SQLERRD(INDEX_3) : 1 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE MASS STATEMENT : FETCH "SQL_CURSOR_0002" EXECUTE: CMD : PARSEID: INPUT : 0000182A 00000401 2A002B00 01000000 SQLCODE: 100 ROW NOT FOUND START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE COMMIT WORK START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE CLOSE "SQL_CURSOR_0002" PARSE : CMD : PARSEID: OUTPUT: 0000182A 00000601 06002800 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE CLOSE "SQL_CURSOR_0002" EXECUTE: CMD : PARSEID: INPUT : 0000182A 00000601 06002800 01000000 PARSEID: SELECT: 00000000 00000000 00000000 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 STMMODE : ORACLE SELECT nuance_key FROM nuance.ndb_timestamp__mmp WHERE nuance_key = ? FOR UPDATE OF PARSE : CMD : mfIndex init : 3 PARSEID: OUTPUT: 0000182A 00000701 3C002F00 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 mfIndex delete : 3 PARSEID: DROP : 0000182A 00000701 3C002F00 01000000 START : DATE : 2002-10-31 TIME : 0010:52:33 END : DATE : 2002-10-31 TIME : 0010:52:33 SQCDROPPARSID PARSEID: : 0000182A 00000701 3C002F00 01000000 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
