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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-63
Examples of SHOWCONTROL
•
Display output when CONTROL TABLE has not been executed in the current
session:
SHOWCONTROL TABLE;
No CONTROL TABLE settings are in effect.
--- SQL operation complete.
•
Issue multiple CONTROL TABLE statements followed by a SHOWCONTROL
TABLE:
CONTROL TABLE PERSNL.JOB MDAM 'OFF';
--- SQL operation complete.
CONTROL TABLE * TIMEOUT '3000';
--- SQL operation complete.
SHOWCONTROL TABLE;
CONTROL TABLE SAMDBCAT.PERSNL.JOB
MDAM OFF
CONTROL TABLE *
TIMEOUT 3000
--- SQL operation complete.
•
Issue multiple CONTROL QUERY DEFAULT statements followed by a
SHOWCONTROL DEFAULT:
SET CATALOG SAMDBCAT;
CONTROL QUERY DEFAULT ISOLATION_LEVEL 'READ UNCOMMITTED';
--- SQL operation complete.
CONTROL QUERY DEFAULT TIMEOUT '1000';
--- SQL operation complete.
SHOWCONTROL DEFAULT;
CONTROL QUERY DEFAULT
CATALOG SAMDBCAT
ISOLATION_LEVEL READ UNCOMMITTED
TIMEOUT 1000
--- SQL operation complete.
Note that the catalog name is set by the SET CATALOG statement.