SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-7
CATALOG Command
CATALOG Command
CATALOG is an SQLCI command that sets the default catalog in an SQLCI session.
catalog
is a catalog name (a Guardian subvolume name) with or without a node and
volume qualifier. It cannot be a DEFINE.
If you omit catalog, SQLCI resets the default to the value of the CATALOG
attribute of the =_DEFAULTS DEFINE that SQLCI inherited from the process that
started the session. If you omit the node and volume qualifier, SQLCI uses the
current defaults.
Considerations—CATALOG

Whenever the default catalog is empty, SQL uses the default subvolume for the
default catalog.

Unless a CONTROL QUERY BIND NAMES AT EXECUTION directive is in effect
when a PREPARE executes, a prepared statement uses the node, volume, and
catalog defaults in effect at the time of the PREPARE and is not affected by a
change in the default catalog. For more information, see CONTROL QUERY
Directive on page C-74 or Name Resolution on page N-2.

CATALOG alters the CATALOG attribute of the =_DEFAULTS DEFINE. Changing
the CATALOG attribute with ALTER DEFINE =_DEFAULTS has exactly the same
effect as issuing a CATALOG command.
Example—CATALOG
CATALOG \SYS1.$VOL1.PERSNL;
CATALOG INVENT;
CATALOG [ catalog ] ;