SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-8
ALTER CATALOG Statement

ALLOCATE affects the number of extents, but not the size of extents. The EXTENT
file attribute determines the extent size.
ALTER CATALOG Statement
ALTER CATALOG is a DDL statement that alters security attributes for an entire
catalog.
catalog
is the name of the catalog to alter (or an equivalent DEFINE). If HP NonStop
Storage Management Foundation (SMF) is installed on your node, catalog must
be either virtual or a direct name.
The clauses set these security-related file attributes for the catalog:
For more information, see System Catalog on page S-92 or an entry for a specific
attribute.
This statement does not affect the system catalog CATALOGS table. You must
alter that table with the ALTER TABLE statement.
Considerations—ALTER CATALOG

To alter security attributes for a catalog, you must be a generalized owner of the
catalog.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to run an ALTER CATALOG
statement while another process is executing a DDL operation on an object in the
catalog.
The specific error depends on the DDL operation involved and the phase of the
operation during which the conflict occurs. For more information, see DDL (Data
Definition Language) Statements on page D-20.
{| { [NO]CLEARONPURGE } |}
{| NOPURGEUNTIL date |}
ALTER CATALOG catalog {| OWNER group,user |}
{| SECURE "rwep" |}
CLEARONPURGE Controls disk erasure when files are dropped
NOPURGEUNTIL Sets date after which drop is allowed
OWNER Specifies owner
SECURE Sets Guardian security string