Re: Current processed SQL statement
In <sMJ+$HAPTmN1EwBp@smooth1.demon.co.uk> David Williams <djw@smooth1.demon.co.uk> writes:
>>SELECT sqx_sessionid,
>> sqx_selflag[4,12] sttmt_type,
>> sqx_sqlstatement statement
> Itsn't sqz_sqlstatement only char(200). I have larger statements.
> onstat -g sql can get the full statement, what is going on?
Use syssqlcurses, field scs_sqlstatement. That one's 32000 long, and should
be OK for most queries :) <Version 7.20+, I think>
--
Bryan Tonnet
batonnet@phase4.com.au