SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-67
Examples—DROP SYSTEM CATALOG
You cannot enter the DROP SYSTEM CATALOG command, however, while the
SQLCI2 program is running, as it normally is after you enter a command during the
current SQLCI session. If you attempt to enter the DROP SYSTEM CATALOG
command while SQLCI2 is running, the command terminates abnormally and an
error message appears.
To enter the command correctly, you can use either of two methods:

Exit from SQLCI. Then restart SQLCI and enter the DROP SYSTEM
CATALOG command at the first SQLCI prompt:
30> SQLCI
>> DROP SYSTEM CATALOG catalog-name;

Enter the DROP SYSTEM CATALOG command at the TACL prompt:
31> SQLCI DROP SYSTEM CATALOG catalog-name;
Examples—DROP SYSTEM CATALOG

This example drops a system catalog that resides on the default location
$SYSTEM.SQL:
16> SQLCI DROP SYSTEM CATALOG $SYSTEM.SQL;

This example drops a system catalog that resides on the volume $VOL1 and
subvolume SVOL1:
18> SQLCI DROP SYSTEM CATALOG $VOL1.SVOL1;
DSL Statements
A DSL statement retrieves status information about the version of the database. This
table summarizes DSL statements:
For detail, refer to the specific statement.
GET CATALOG OF SYSTEM
Statement
Retrieves the name of a local or remote system
catalog
GET VERSION Statement Retrieves the version of a specific SQL object,
catalog, or system
GET VERSION OF
PROGRAM Statement
Retrieves the PCV, PFV, or HOSV of an SQL
program