Reports the text of a particular query batch being executed for a particular process. This text can only be an initial substring of the complete text in a query batch. The maximum amount of text stored in this field is determined by the Adaptive Server configuration option max SQL text monitored and can be monitored using SMC_NAME_CUR_STMT_BATCH_TEXXT ENABLED.
11.5 and later
Result
No
SMC_NAME_SPID
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
---|---|---|---|---|---|
CHARP |