Activate database-request statement caching for all users by user type

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

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

Enter the number for the statement caching 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 — Report 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.

After selecting the statement caching type, the following menu appears:

Enter the user type for statement caching activation or Q to Quit (1-ABL Local, 2-ABL Remote, 3-SQL, 4-All Remote 5-All Clients):

• 1─ABL Local—Specifies all ABL local clients.
• 2─ABL Remote—Specifies all ABL remote clients.
• 3─SQL—Specifies all SQL remote clients.
• 4─ALL Remote—Specifies all remote clients including, both ABL and SQL.
• 5─All Clients—Specifies all self-service (local) clients and all remote clients.

After you select the user type for database-request statement caching, tracing is activated for the specified user type currently connected to the database.