NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
G-8
Considerations—Guardian Names
file-id
is the name of a Guardian disk file or the name of a NonStop SQL/MP table, view,
index, partition, collation, or program. The name consists of a letter followed by 1 to
7 letters or digits. This portion of the name is sometimes called the “simple file
name.”
Considerations—Guardian Names
•
Name expansion
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). See Name Resolution
on page N-2 or CONTROL
QUERY Directive on page C-70 for more information.
Examples—Guardian Names
The following are all Guardian names:
ORDERS
SALES.ORDERS
$VOL1.SALES.ORDERS
\SYS1.$VOL1.SALES.ORDERS