SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-67
SQLCODE
For more information about a specific SQLCI command, see the entry for that
command.
SQLCODE
SQLCODE is a variable in a host program to which SQL returns status information.
For more information about SQLCODE, see the SQL/MP programming manual for your
host language.
SQLCOMP Command
The SQLCOMP command starts the SQL/MP compiler from a TACL process in the
Guardian environment. You use SQLCOMP to SQL-compile Guardian host language
programs that contain embedded SQL statements.
For information about SQLCOMP, see the SQL/MP programming manual for your host
language.
Standards Conformance
NonStop SQL/MP complies most closely with Entry Level SQL as described in
ANSI X3.135-1992 and ISO/IEC 9075:1992. NonStop SQL/MP also includes some
features from Intermediate and Full Level ANSI/ISO SQL in addition to special HP
extensions to the SQL language.
The remainder of this entry summarizes the exceptions and extensions to the
standard.
Exceptions to Conformance With Entry Level SQL 1992
This list summarizes the major ways in which NonStop SQL/MP does not conform to
ANSI/ISO Entry Level SQL:

Catalog, schema, table, view, and collation names
UPGRADE
CATALOG Command
Upgrades catalogs to a newer version of NonStop SQL/MP
UPGRADE SYSTEM
CATALOG Command
Upgrades the system catalog to a newer version of NonStop
SQL/MP
VERIFY Command
Checks the consistency and validity of object definitions in catalogs
and file labels; lists invalid programs
VOLUME Command
Changes the default volume or subvolume
! Command
Reexecutes a previous command
Table S-2. Summary of SQLCI Commands (page4of4)
Command Action