SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-114
Examples of QUERYCACHEENTRIES
Examples of QUERYCACHEENTRIES
•
Display all information contained in the QUERYCACHEENTRIES table. Note that
the output has been formatted for readability.
>>SET SCHEMA SAMDBCAT.PERSNL;
--- SQL operation complete.
>SELECT * FROM EMPLOYEE;
Employee/Number First Name Last Name Dept/Num Job/Code Salary
-------------- -------------- -------------- -------- -------- ---------
1 ROGER GREEN 9000 100 175500.00
23 JERRY HOWARD 1000 100 137000.10
29 JANE RAYMOND 3000 100 136000.00
.
.
.
--- 62 row(s) selected.
>SELECT * FROM DEPT;
Dept/Num Dept/Name Mgr Rpt/Dept Location
-------- ------------ ----- -------- ------------------
1000 FINANCE 23 9000 CHICAGO
1500 PERSONNEL 213 1000 CHICAGO
2000 INVENTORY 32 9000 LOS ANGELES
.
.
.
--- 12 row(s) selected.
>SELECT * FROM JOB;
Job/Code Job Description
-------- ------------------
SHAPE CHAR(1024) Required CONTROL QUERY SHAPE of the query
associated with this entry. Blank if no required
shape.
ISOLATION_LEVEL CHAR(20) Transaction isolation level for this entry. Can be
READ UNCOMMITTED, READ COMMITTED,
REPEATABLE READ, SERIALIZABLE, or NOT
SPECIFIED.
ACCESS_MODE CHAR(20) Transaction access mode value associated with
this entry. Can be READ ONLY, READ WRITE, or
NOT SPECIFIED.
AUTO_COMMIT CHAR(15) Transaction autocommit value associated with this
entry. Can be ON, OFF, or NOT SPECIFIED.
ROLLBACK_MODE CHAR(15) Transaction rollback mode value associated with
this entry. Can be WAITED, NO WAITED, or NOT
SPECIFIED.
Column Name Data Type Description