SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-115
Considerations for QUERYCACHEENTRIES
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