SMC_NAME_CUR_STMT_BATCH_TEXT

Description

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.

Version compatibility

11.5 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

CHARP