Last parsed SQL statement...

Is it possible to get last parsed statement is ESQL/C (like onstat -g ses id_ses)? Query is saved in sysmaster database, but where can I found session id? Thank you for anserws... ______________________________________________________________________________ Jaroslaw Poswiata Gdynia Obluze tel. kom. 0601 256 192 prezes@ctm.gdynia.pl

DBINFO('sessionid') returns the current session number. For example, SELECT DBINFO('sessionid') FROM systables WHERE tabname = 'systables'; will return your current session. If its all sessions you want, look into sysmaster:syssessions Rudy Jaroslaw Poswiata wrote: > Is it possible to get last parsed statement is ESQL/C (like onstat -g > ses id_ses)? Query is saved in sysmaster database, but where can I found > session id? > > Thank you for anserws... > ______________________________________________________________________________ > Jaroslaw Poswiata Gdynia Obluze > tel. kom. 0601 256 192 prezes@ctm.gdynia.pl