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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-64
Examples of SHOWCONTROL
•
Change the TIMEOUT attribute and then issue a SHOWCONTROL DEFAULT for
TIME, which is a reserved word:
CONTROL QUERY DEFAULT TIMEOUT '2000';
--- SQL operation complete.
SHOWCONTROL DEFAULT "TIME", MATCH PARTIAL;
CONTROL QUERY DEFAULT
TIMEOUT 2000
Current DEFAULTS
STREAM_TIMEOUT -1
TIMEOUT 2000
--- SQL operation complete.
In this example, the TIME name matches the TIMEOUT and STREAM_TIMEOUT
attributes.
•
Change the CATALOG attribute and then issue a SHOWCONTROL DEFAULT for
CAT:
CONTROL QUERY DEFAULT CATALOG 'SAMDBCAT';
--- SQL operation complete.
SHOWCONTROL DEFAULT CAT;
CONTROL QUERY DEFAULT
CATALOG SAMDBCAT
Current DEFAULTS
CATALOG SAMDBCAT
SCHEMA PERSNL
--- SQL operation complete.
In this example, the CAT name matches only the CATALOG attribute. Note that the
SCHEMA attribute is always displayed if the CATALOG attribute is displayed, and
the reverse is also true.