SQL/MP Programming Manual for COBOL85

HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
5-1
5 SQL/MP System Procedures
Table 5-1 describes the NonStop SQL/MP system procedures a COBOL program can
call to return various SQL information. These procedures are described alphabetically
on subsequent pages in this section.
Table 5-1. SQL/MP System Procedures
Procedure Description
To Use With Dynamic SQL Operations
SQLADDR Returns the address of an input parameter, output
variable, or indicator variable to an input or output
SQLDA structure (used only in dynamic SQL operations)
To Return Error and Warning Information
SQLCA_DISPLAY2_ Writes to a file or terminal the error and warning
messages that SQL/MP returns to the SQLCA structure
SQLCA_TOBUFFER2_ Returns to a record area in the program the error or
warning messages that 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
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
SQL/MP returns to the SQLSA structure
To Return Error and Warning Information (Superseded Procedures)
SQLCADISPLAY Writes error or warning messages from the SQLCA
structure to a file or terminal (superseded by
SQLCA_DISPLAY2_)
SQLCATOBUFFER Writes error or warning messages from the SQLCA
structure to a record area (superseded by
SQLCA_TOBUFFER2_)