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.
11.5 and later
Result
Yes
None
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
---|---|---|---|---|---|
LONG |