SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
G-8
Considerations—Guardian Names
letters or digits. This portion of the name is sometimes called the “simple file
name.”
Considerations—Guardian Names
If you do not fully qualify a Guardian name, SQL uses the current default node,
volume, and subvolume names to expand the name as needed at name-resolution
time. You can change the current defaults in effect for a program by changing the
defaults in the process that executes the program or by setting the =_DEFAULTS
DEFINE in the program. You can change the current defaults in SQLCI with the
VOLUME or CATALOG commands or by setting the =_DEFAULTS DEFINE.
The time at which name resolution occurs depends on the statement in which a name
is used and whether a CONTROL QUERY BIND NAMES AT EXECUTION directive
was in effect at the time the statement was compiled or prepared (compiled with the
PREPARE statement). For more information, see Name Resolution on page N-2 or
CONTROL QUERY Directive on page C-74.
Example—Guardian Names
These are all Guardian names:
ORDERS
SALES.ORDERS
$VOL1.SALES.ORDERS
\SYS1.$VOL1.SALES.ORDER