When you choose to view the database-request statement cache, the following menu appears:

                OpenEdge Release 12 Monitor (R&D)
                View Client Statement Cache
 
Usr:Ten Name    Domain   Type       Login time     Serv IPV# Remote Address
  5     User-5      -4   SELF/ABL   04/08/20 12:23    0   
  6     User-6      -4   SELF/ABL   04/08/20 12:23    0   
  7     User-7      -4   SELF/ABL   04/08/20 12:23    0   
  8     User-8      -4   SELF/ABL   04/08/20 12:23    0   

Enter user number, P, T, or X (? for help): 6

                OpenEdge Release 12 Monitor (R&D)
                View Client Statement Cache

User number                     : 6
User name                       : User-6         
User type                       : SELF/ABL     
Login date/time                 : 04/08/20 12:23

Statement caching type          : SQL Statement or Single ABL Program Name          
Statement caching last updated  : 04/08/20 14:11

Statement cache                 :  -1 : d_mar18.p
                                  2 : /scratch/doc/116/p94309_Untitled1.ped


Enter user number, P, T, or X (? for help):

The following table provides information about fields in the View Client Statement Cache display.

Table 1. View client statement cache display fields
Field Description
User number The user number associated with the database connection.
Name The user name associated with the connected user.
User Type The type of database connection.
Login date/time The date and time the user connected to the database.
Statement cache type SQL statement or Single ABL Program Name — The statement cache information contains a single SQL statement or a partial ABL program line number.

SQL statement or Partial ABL Program Name — The statement cache information contains a single SQL statement or a partial ABL program stack containing ABL program names and line numbers.

One Time SQL Statement or Partial ABL Program Name — The statement cache information contains a one time request of a single SQL statement or a partial ABL program stack containing ABL program names and line numbers.
Statement cache last updated The date and time the database-request statement cache was updated.
Statement cache The SQL statement or ABL program information for the last database request made by the client. This field may change, if:
  • The client is an ABL client, the line number is shown followed by the ABL program name. The line number displayed is the one generated by the compiled listing of the ABL program; it may not match the contents of the ABL source code.
  • The client is a SQL client; the SQL statement is displayed.