SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-21
CLEANUP Command

This example returns 20:
CHAR_LENGTH ( EMPNAME )

This example returns 21—not 100—because it is a VARCHAR value:
CHAR_LENGTH ( ADDRESS )
CLEANUP Command
CLEANUP is an SQLCI utility command that allows a user with super ID authority to
delete damaged SQL objects, SQL programs in Guardian files, and catalogs and
associated file labels and shadow labels from the local node.
qualified-fileset-list
is a qualified fileset list that specifies SQL objects to delete. (For information, see
Qualified Fileset List on page Q-1.) If SMF is installed,
qualified-fileset-list cannot specify a file on a $*.ZYS*. subvolume.
CLEANUP does not delete catalog tables and indexes included in
qualified-fileset-list unless you also specify the CATALOG[S] option.
CLEANUP does not delete Enscribe files other than SQL programs. CLEANUP
does not delete OSS files, even if they contain SQL programs.
If an object's file label no longer exists, you can use the FROM CATALOG clause
to specify the object, but you cannot use a WHERE expression. If you use both,
CLEANUP issues an error message and does not delete the object.
!
(either before or after qualified-fileset-list) directs CLEANUP to delete
all objects in the specified filesets without prompting for confirmation.
Caution. Use CLEANUP only when absolutely necessary to delete damaged objects.
CLEANUP deletes both damaged and undamaged objects in the fileset you specify. Misusing
CLEANUP can corrupt your SQL data dictionary. Never use CLEANUP as a substitute for
DROP or PURGE.
CLEANUP [!] qualified-fileset-list [!] [ , option ] ;
{ CATALOG[S] }
option is: { NO CATALOG[S] [ , SHADOWSONLY ] }
{ SHADOWSONLY [ , NO CATALOG[S] ] }