query for sessions last sql statement

when I query the syssqlstat table for session information I get a truncated version of the sql statment (sqs_statement column only 200 chars) Are there any other tables or views ins sysmaster which store the full sql statement. I know I can get this from onstat -g sql/ses but I'd like to access this from a client session. Thanks for any help...

The syconblock table probably has the info you are looking for Will In article <8eujp8$btv$1@news.mathworks.com>, "Ben Draper" <bdraper@mathworks.com> wrote: > when I query the syssqlstat table for session information I get a truncated > version of the sql statment (sqs_statement column only 200 chars) > > Are there any other tables or views ins sysmaster which store the full sql > statement. I know I can get this from onstat -g sql/ses but I'd like to > access this from a client session. > > Thanks for any help... > > Sent via Deja.com http://www.deja.com/ Before you buy.

Ben Draper <bdraper@mathworks.com> wrote in message news:8eujp8$btv$1@news.mathworks.com... > when I query the syssqlstat table for session information I get a truncated > version of the sql statment (sqs_statement column only 200 chars) > > Are there any other tables or views ins sysmaster which store the full sql > statement. I know I can get this from onstat -g sql/ses but I'd like to > access this from a client session. select scs_sqlstatement from syssqlcurses where scs_sessionid= <sessionid> or select cbl_stmt from sysconblock where sbl_sessionid= <session id> where sql-statement maybe down to 32000 -- Best regards Vasyl Shulzhenko