When you choose option 3 or 3a in the Client Database-Request Statement Caching menu to activate database-request statement caching for all future users, the following menu appears:

Enter the type of statement caching to activate or Q to Quit 
(1-Single, 2-Stack,Q-Quit):

Enter the number for the type, or Q to exit:

  • 1-Single — The ABL client reports only the current ABL program and line number, or a single SQL statement.
  • 2-Stack — Report the call stack up to the current ABL program and line number.
  • Q-Quit — Quit this function and return to the Client Database-Request Statement Caching menu.

After the type of database-request statement caching is selected, tracing is activated for all clients of the specified type that will connect to the database in future.

Note: Once activated, database-request statement caching remains activated until deactivated.

Activating database-request statement caching for all future users changes the value of the startup parameter -clstmtCacheLevel. For more information, see Client Database-Request Statement Caching Level (-clstmtCacheLevel).