SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

M-40

MODIFY REGISTER Command

The MODIFY REGISTER command registers a user-defined catalog in the local

system catalog.

Each node that uses NonStop SQL/MP has a catalog called the system catalog that

contains information about all the catalogs on the node. If a disk containing an SQL

database is moved from one node to another, the catalogs that reside on the relocated

disk are not automatically registered in the system catalog on the new node. You can

access a catalog that is not registered in the system catalog or even create new

objects and register them in such a catalog. However, to make the system consistent,

you should register all user-defined catalogs in the SQL system catalog.

CATALOG catalog-list-1 [ EXCLUDE catalog-list-2 ]

identifies one or more SQL catalogs to be registered in the system catalog. If the

catalog is already registered in the system catalog, a warning is reported, and the

command continues.

The optional EXCLUDE catalog-list-2 clause specifies catalogs to be

excluded from catalog-list-1.

catalogset specifies one catalog or a set of catalogs. To specify a single

catalog, enter the name of the catalog (the name of the subvolume that contains

the catalog). To specify multiple volumes, use wild-card characters. You can use

these wild-card characters:

MODIFY [ DICTIONARY ] REGISTER target-spec

[ [,] option ] ...;

target-spec is:

CATALOG catalog-list-1 [ EXCLUDE catalog-list-2 ]

catalog-list-n (where n = 1,2) is:

{ catalogset }

{ ( catalogset [ , catalogset ] ... ) }

option is:

[| ALLOWERRORS [ OFF | ON | number-of-errors ] |]

[| [ NO ] LISTALL |]

* Matches 0 to 8 characters in the position where it appears. Specifying

only an asterisk indicates any name is acceptable. To specify all

catalogs, use either $*.* or *.*.

? Matches any single character.