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

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

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.
  • 3-One Time Request — The ABL or SQL client report tracing information once and then turn off database-request statement caching.
  • Q-Quit — Quit this function and return to the Client Database-Request Statement Caching menu.

Once the type of database-request statement caching is selected, tracing is activated for all clients currently connected to the database.

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