SMC_NAME_CUR_STMT_BATCH_TEXT_ENABLED

Description

Reports whether Adaptive Server is saving the SQL text of the currently executing query batches, and if so, how much.

Value of 0 = saving SQL text disabled.

Value of 1 or more = maximum number of bytes of batch text per server process that can be saved.

Version compatibility

11.5 and later

Data item type

Result

Server level

Yes

Required keys

None

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG