You can configure the amount of the SQL text batch you want to save. When text saving is enabled, Adaptive Server copies the subsequent SQL text batches to memory shared with SQL Server Monitor. Because each new batch clears the memory for the connection and overwrites the previous batch, you can view only currently executing SQL statements.
Saving SQL text
Configure the amount of SQL text retained in memory (see “Configuring the amount of SQL text retained in memory”).
Enable SQL Server to start saving SQL text (see “Enabling Adaptive Server to start saving SQL text”).
You must have System Administration privileges to configure
and save SQL text batches.
