SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-34
Summary of DEFINE Attributes
statements as the logical name of a table, view, index, collation, partition, or program,
altering the DEFINE (but not the SQL statement) when you want to point to a different
physical entity.
For example, this command adds a DEFINE that assigns the logical name =ORDERS
to the table whose name is \SYS1.$VOL2.SALES.ORDERS:
ADD DEFINE =ORDERS, CLASS MAP, FILE \SYS1.$VOL2.SALES.ORDERS;
While this DEFINE is in effect, you can refer to the table as =ORDERS in SQL
statements.
MAP is the default class unless the working attribute set specifies a different class, so
the previous command is normally equivalent to this one:
ADD DEFINE =ORDERS, FILE \SYS1.$VOL2.SALES.ORDERS;
The working attribute set is a set of default attribute values used when you create a
new DEFINE and do not explicitly specify its attributes. For information about the
working attribute set, see SET DEFINE Command on page S-32, RESET DEFINE
Command on page R-12, and SHOW DEFINE Command on page S-48.
Summary of DEFINE Attributes
The other attributes of a DEFINE vary according to its class. Table D-1 lists the
DEFINE classes and the attributes of each class. It also supplies a brief definition of
attributes commonly used with SQL. For information about attributes of other classes,
see the TACL Reference Manual.
Table D-1. Attributes of DEFINEs (by Class) (page1of3)
Class Attributes
Required/
Optional
CATALOG SUBVOL subvol
specifies an actual subvolume name that identifies a
catalog; subvol is a Guardian subvolume name.
Required
DEFAULTS CATALOG[\node.][$vol.]subvol
specifies the current default catalog. If you omit \node or
$vol, the current value of the corresponding element in
the =_DEFAULTS DEFINE VOLUME attribute is used.
Optional
VOLUME[\node.]$vol.subvol
specifies the current default volume and subvolume. If you
omit \node, the system on which you are running the
process is used.
Required
MAP FILE file-name
specifies an actual file to use when you refer to the
associated DEFINE name in a command.
Required
SEARCH SUBVOL0 subvol-name Optional
RELSUBVOL0 subvol-name Optional