SQL Programming Manual for TAL

HP NonStop SQL Programming Manual for TAL—527887-001
4-1
4 System Procedures
Use the provided system library procedures, written in TAL, to perform various SQL
functions. The EXTDECS file contains source declarations for these procedures. Use
the SOURCE directive to specify the declarations in the EXTDECS file for the
procedures that you want to call in your program. For example, this directive specifies
declarations for the SQLCADISPLAY and SQLCAFSCODE procedures:
?SOURCE $SYSTEM.SYSTEM.EXTDECS ( SQLCADISPLAY,
? SQLCAFSCODE )
Table 4-1 describes the SQL system procedures by function. The procedures
beginning with SQL are described in this section. The FILEINQUIRE procedure is
described in the Guardian Procedure Calls Reference Manual.
Table 4-1. System Procedures for NonStop SQL Operations
Procedure Description
Displaying Errors and Warnings
SQLCADISPLAY Writes to a file or terminal the error and warning messages
that NonStop SQL returns to the program.
SQLCAFSCODE Returns information about file-system, disk-process, or
NonStop Kernel operating system errors returned to the
program.
SQLCAGETINFOLIST Writes to a record area in a program a subset (which you
specify) of the error or warning information in the SQLCA.
SQLCATOBUFFER Writes to a record area in the program the error or warning
messages that NonStop SQL returns to the program.
Displaying Execution Statistics
SQLSADISPLAY Writes to a file or terminal the execution statistics that
NonStop SQL returns to the program.
Retrieving Version Information
SQLGETCATALOGVERSION Returns a value that indicates the version of an SQL
catalog.
SQLGETOBJECTVERSION Returns a value that indicates the version of an SQL
objects (represents the oldest NonStop SQL release that
can perform all DML and most DDL operations for a given
SQL table, index, or view.)
SQLGETSYSTEMVERSION Returns a value that indicates the version of the NonStop
SQL file-system and disk-process components on a given
system.
Determining the Catalog for a Table, Index, or View
FILEINQUIRE (Guardian
procedure)
Returns information about a file. The input codes 13 and
14 apply specifically to SQL objects.