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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-61
SHOWCONTROL Command
SHOWCONTROL Command
Examples of SHOWCONTROL
The SHOWCONTROL command displays the access plan, controls, and system
defaults in effect.
Use SHOWCONTROL only within an MXCI session.
[QUERY] SHAPE
displays the access plan (or control query shape) in effect, which is the result of
the last CONTROL QUERY SHAPE statement that is executed. See CONTROL
QUERY SHAPE Statement on page 2-35.
TABLE
displays all controls in effect that are the result of CONTROL TABLE statements.
See CONTROL TABLE Statement on page 2-46.
table [,MATCH {FULL | PARTIAL}]
displays only the table controls in effect that match, either fully or partially, the
table used in CONTROL TABLE statements. The match is not case-
sensitive.
MATCH FULL specifies that table must be the same as the table name used
in CONTROL TABLE statements. MATCH PARTIAL specifies that table must
be included in the table name used in CONTROL TABLE statements. The
default is MATCH PARTIAL.
[QUERY] DEFAULT
displays all system defaults in effect that are the result of executing CONTROL
QUERY DEFAULT statements or executing other statements that also affect the
external system defaults—for example, SET CATALOG. See CONTROL QUERY
DEFAULT Statement on page 2-33.
attribute-name [,MATCH {FULL | PARTIAL}]
displays only the system defaults in effect that match, either fully or partially,
the attribute used in CONTROL QUERY DEFAULT statements. The match
is not case-sensitive.
SHOWCONTROL showcontrol-option
showcontrol-option is:
[QUERY] SHAPE
| TABLE [table [,MATCH {FULL | PARTIAL}]]
| [QUERY] DEFAULT [attribute-name [,MATCH {FULL |
PARTIAL}]]
| ALL