SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-58
DML Statements
DML Statements
A DML statement is used to select, update, insert, or delete rows in one or more
tables. This table summarizes DML statements:
DOWNGRADE CATALOG Command
DOWNGRADE CATALOG is an SQLCI utility command that converts catalogs to an
older version so the catalogs can be accessed by an older version of the SQL/MP
software.
catalogs
specifies the catalogs to downgrade. catalog can be a single catalog name, a
type CATALOG DEFINE name, or a name that specifies multiple catalogs by
including these wild-card characters:
For example,
Catalogs specified by catalogs can be either local or remote but cannot include
objects with a version newer than version, or any catalog specified programs
CLOSE Statement Closes a cursor
DECLARE CURSOR Statement Defines a cursor
DELETE Statement Deletes rows from a table or view
FETCH Statement Retrieves a row from a cursor
INSERT Statement Inserts a row into a table or view
OPEN Statement
Opens a cursor
SELECT Statement
Retrieves data from tables and views
UPDATE Statement Updates values in columns of a table or view
DOWNGRADE CATALOG[S] [ catalogs ] TO version ;
? matches any single character
* matches 0 to 8 characters
MYCAT? matches MYCATA, MYCATB, and MYCAT5 (and possibly others)
but not MYCATXX.
$DATA.* matches all catalogs on volume $DATA.
=APPCAT matches the catalog specified by the =APPCAT DEFINE
(MYCAT?,
=APPCAT)
matches MYCAT1, MYCAT2, MYCATX, (and possibly others) and
the catalog specified by =APPCAT
$*.* matches all catalogs on the current default node except the system
catalog.