NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-12
Considerations—INFO DEFINE
You can specify define as a DEFINE template. A DEFINE template allows you to
use these special characters as part of a name:
In TACL or OSS, but not in SQLCI, you can also use the following special
characters:
DETAIL
requests the value of each attribute for the DEFINE that has a value. If you omit
DETAIL, INFO DEFINE displays only the CLASS attribute and one other attribute
(depending on CLASS).
Considerations—INFO DEFINE
•
INFO DEFINE does not display the working attribute set. (Use SHOW DEFINE to
display the working attribute set.)
Examples—INFO DEFINE
•
The following example displays information about a DEFINE named =ORDERS:
>> INFO DEFINE =ORDERS;
DEFINE NAME =ORDERS
CLASS MAP
FILE $VOL1.SALES.ORDERS
•
The following example displays information about the current =_DEFAULTS
DEFINE:
>> INFO DEFINE =_DEFAULTS;
DEFINE NAME =_DEFAULTS
CLASS DEFAULTS
VOLUME $VOL1.SALES
INITIALIZE SQL Command
INITIALIZE SQL is an SQLCI command that allows a user with the local super ID to
ensure that SQL is using compatible components and to prepare a node to run NonStop
** Matches all DEFINE names
=* Matches all DEFINE names
* Matches 0 or more characters at the same position
? Matches one character in the same position