SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-48
Shorthand View
Shorthand View
A shorthand view is a view derived from one or more tables or views by joining tables
or views, by projecting columns, by restricting rows, or by a combination of these
actions. Shorthand views can be read, but cannot be updated or secured.
SHOW CONTROL Command
SHOW CONTROL is an SQLCI command that displays the current values of options
set by the CONTROL EXECUTOR, CONTROL QUERY, and CONTROL TABLE
statements.
Example—SHOW CONTROL
>> SHOW CONTROL;
---------------------------------------------
Current Environment
---------------------------------------------
CONTROL TABLE ORDERS TABLELOCK OFF
CONTROL TABLE ORDERS TIMEOUT 10.00 SECONDS
CONTROL TABLE ORDERS SEQUENTIAL UPDATE ON
CONTROL TABLE ORDERS SYNCDEPTH 1
CONTROL TABLE ORDERS MDAM ON
CONTROL TABLE ORDERS MDAM USE 3 KEY COLUMNS
CONTROL TABLE ORDERS MDAM ACCESS DENSE
SHOW DEFINE Command
SHOW DEFINE is an SQLCI command that displays all or part of the working
attributes set. (SHOW DEFINE is similar to the TACL command SHOW DEFINE and
the OSS command show_define.)
attr
displays the attribute you specify and its value. You can specify any attribute that is
legal for the current class. (If you do not know the current class, specify CLASS.)
*
displays all attributes in the working attribute set and their values. Optional
attributes that have no current value are not displayed.
SHOW CONTROL ;
SHOW DEFINE [ attr ] ;
[ * ]