When you choose to activate database-request statement caching for all users, the following menu appears:

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

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

  • 1-Single — Only the current ABL program and line number, or a single SQL statement is reported by the ABL client.
  • 2-Stack — 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. Once reported, database-request statement caching is turned off.
  • 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.