SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

X-3

=_DEFAULTS DEFINE

=_DEFAULTS is a system DEFINE that specifies the current default node, volume,

subvolume, and catalog. =_DEFAULTS determines how to expand partially qualified

Guardian names.

=_DEFAULT always has a VOLUME attribute that specifies the current default volume

and subvolume. If =_DEFAULT has a CATALOG attribute, that attribute specifies the

current default SQL catalog; if not, the VOLUME attribute specifies the subvolume that

is the current default SQL catalog.

You cannot rename or delete the =_DEFAULTS DEFINE, but you can display and alter

it.

CATALOG [\node.][$volume.]subvolume

sets the current default catalog, which is used wherever a catalog name is required

but no CATALOG clause is supplied, such as in DDL statements or in the SQL

compiler command.

VOLUME [\node.][$volume.]subvolume

sets the current default node, volume, and subvolume. The file system uses the

current defaults to expand a partially specified Guardian name to a fully qualified

name.

Considerations—=_DEFAULTS



Processes started during a TACL session automatically inherit the =_DEFAULTS

DEFINE from the TACL session, regardless of the DEFMODE setting.



You can alter =_DEFAULTS explicitly using the ALTER DEFINE command. You

can alter it implicitly using the VOLUME, SYSTEM, and CATALOG commands.

If you alter =_DEFAULTS from SQLCI, you alter it only for the duration of the

SQLCI session, not for the TACL session that started the SQLCI session.



With the introduction of the kernel-managed swap facility, the SWAP option is

ignored but is stored so that programs can continue to use the information when

creating temporary files.

ALTER DEFINE =_DEFAULTS,

{| CATALOG [\node.][$volume.]subvolume |}

{| |}

{| VOLUME [\node.][$volume.]subvolume |} ;