I am using the Sql Trace option to trace on the baan seesions using the set commands in the bw client

The dbs log trace gives me the query output but not the actual values passed to that query. Our database is sql2000 and
type 1 driver. Is there is any way I can catch the actual values passed to the query in the trace options. I have attached the
sample output i am seeing on the trace log file.

1524> 2002-10-31[09:55:30]: Logging started mode 04460
---- LOG TABLE INFO [0000020] ----
---- LOG DB INFO [0000040] ----
---- LOG SQL INFO [0000400] ----
---- LOG DUB INFO [0004000] ----



1524> baan [41]--------- D_START_TRANS on session ------------


SQL> {call dbo.Pttfgld430400_1( ?, ? )}


SQL> {call dbo.Pttfgld014400_1( ?, ? )}


SQL> {call dbo.Pttfgld014400_1( ?, ? )}


SQL> UPDATE dbo.ttfgld014400 SET t_year = ?, t_lbno = ?, t_prun = ?, t_Refcntd = ?, t_Refcntu = ?, hash1 = ? WHERE hash1 = ?


SQL> {call dbo.Pttfgld100400_1( ?, ? )}


SQL> {call dbo.Pttfgld006400_1( ?, ? )}


SQL> INSERT INTO dbo.ttfgld100400 (t_year, t_btno, t_stat, t_user, t_tedt, t_trdt, t_itbc, t_fprd, t_rprd, t_vprd, t_vyer, t_bref, t_btyp, t_trun, t_tstt, t_selt, t_Refcntd, t_Refcntu, hash1, hash2, hash3, hash4, hash5) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Hi mraja71 - I recently had to figure the same thing out.

I used DBSLOG=0100, then in the dbs.log file I searched on the "“DBMS Update Input” phrase, there it gave me the exact record it was "trying" to insert in my table.

Attached is a good doc on tracing.

Hello mraja71

You need row information, so you should add value 010 to your DBSLOG value. I think 04470 should be useful.

Guilmor