SQL/MP Programming Manual for C

HP NonStop SQL/MP Programming Manual for C—429847-008
5-1
5 SQL/MP System Procedures
Table 5-1 describes the NonStop SQL/MP system procedures, which are written in
TAL, that a C program can call to return various SQL information. These procedures
are listed alphabetically.
Table 5-1. SQL/MP System Procedures
Procedure Description
To Return Error and Warning Information
SQLCADISPLAY Writes to a file or terminal the error and warning
messages that NonStop SQL/MP returns to the
SQLCA structure.
SQLCAFSCODE Returns information about file-system, disk-process, or
operating system errors from the SQLCA structure.
SQLCAGETINFOLIST Returns to an area in the program a specified subset of
the error or warning information in the SQLCA
structure.
SQLCATOBUFFER Returns to a record area in the program the error or
warning messages that NonStop SQL/MP returns to
the SQLCA structure.
To Return Version Information
SQLGETCATALOGVERSION Returns the version of an SQL catalog.
SQLGETOBJECTVERSION Returns the version of an SQL object (table, index, or
view).
SQLGETSYSTEMVERSION Returns the version of the SQL file-system and
disk-process components for a specified system.
To Return Execution Statistics
SQLSADISPLAY Writes to a file or terminal the execution statistics that
NonStop SQL/MP returns to the SQLSA structure.