Hi,

I am coddled with the trace-File from ODBC and Embedded-Sql.
When i use the trace-File from the native jdbc-Driver
i see shortened trace-Infos. For example, there is no 
start and end-Time-Information.

Is it possible to switch the trace-Level, to get this additional
Information ?
You can say use the jdbc-odbc-Bridge to get the detailed Info, but
for example in Linux i can�t use this feature.

Regards Matthias Lak�mper



//-----------Jdbc-Trace-excerpt------------------------------
Connection(78a212)::getMetaData ()
 <-getMetaData: com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@3a9340
DatabaseMetaData(551d7f)::getIdentifierQuoteString ()
 <-getIdentifierQuoteString: "
Connection(78a212)::prepareStatement (select ident_nr , art_bez_1, art_bez_2 from 
pps_tst_basis where ident_nr between 1 and 5)
 <-prepareStatement: com.sap.dbtech.jdbc.CallableStatementSapDB@4931fc
PreparedStatement(3820e)::executeQuery ()
 <-executeQuery: com.sap.dbtech.jdbc.ResultSetSapDB@486be5
ResultSet(23b25c)::getMetaData ()
 <
//-----------Jdbc-Trace-excerpt------------------------------

//-----------Odbc-Trace-excerpt------------------------------
DECLARE "SQL_CURSOR_0003" CURSOR FOR SELECT FUNKTION_01, FUNKTION_02 , 
FUNKTION_03, FUNKTION_04 , FUNKTION_05, FUNKTION_06, FUNKTION_07, FUNKTION_08 , 
FUNKTION_09, FUNKTION_10  FROM YCODE_TABELLE WHERE TAB_FUNKTION = ? AND 
LOKATION = ? AND CODE_01 = ? AND CODE_02 = ? AND FUNKTION_01 = ?
EXECUTE: CMD   :  
PARSEID: INPUT :  00EA06A00B0000013C002C00
INPUT  :    1: COLUMN1                         : MNU
INPUT  :    2: COLUMN2                         : 
INPUT  :    3: COLUMN3                         : LGW
INPUT  :    4: COLUMN4                         : ALMES
INPUT  :    5: COLUMN5                         : DV00DV07
SQLRESULTNAME  :  SQL_CURSOR_0003    
SQLERRD(INDEX_3) : -1         
START  :  DATE :  2002-04-11    TIME :  0013:55:50
END    :  DATE :  2002-04-11    TIME :  0013:55:50
 
MFETCH "SQL_CURSOR_0003"
PARSE  : CMD   :  
PARSEID: OUTPUT:  00EA06A00D0000012A002B00
START  :  DATE :  2002-04-11    TIME :  0013:55:50
END    :  DATE :  2002-04-11    TIME :  0013:55:50
 
MFETCH "SQL_CURSOR_0003"
EXECUTE: CMD   :  
PARSEID: INPUT :  00EA06A00D0000012A002B00
OUTPUT :    1: FUNKTION_01                     : abc123
OUTPUT :    2: FUNKTION_02                     : hallo
OUTPUT :    3: FUNKTION_03                     : hier
OUTPUT :    4: FUNKTION_04                     : info
OUTPUT :    5: FUNKTION_05                     : xy
OUTPUT :    6: FUNKTION_06                     :  IS NULL
OUTPUT :    7: FUNKTION_07                     :  IS NULL
OUTPUT :    8: FUNKTION_08                     :  IS NULL
OUTPUT :    9: FUNKTION_09                     : xxx
OUTPUT :   10: FUNKTION_10                     : xxxxxxxxxxxxxxxx
//-----------Odbc-Trace-excerpt------------------------------


________________________________________________________________
Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! 
Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to