SQL/MP Programming Manual for COBOL

HP NonStop SQL/MP Programming Manual for COBOL—529758-003
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
on page 5-3 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_
on
page 5-4
Writes to a file or terminal the error and warning
messages that SQL/MP returns to the SQLCA structure
SQLCA_TOBUFFER2_
on
page 5-11
Returns to a record area in the program the error or
warning messages that SQL/MP returns to the SQLCA
structure
SQLCAFSCODE
on page 5-17 Returns information about file-system, disk-process, or
operating system errors from the SQLCA structure
SQLCAGETINFOLIST
on
page 5-17
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
on page 5-24
Returns the version of an SQL catalog
SQLGETOBJECTVERSION
on
page 5-25
Returns the version of an SQL object (table, index, or
view)
SQLGETSYSTEMVERSION
on
page 5-26
Returns the version of the SQL file-system and disk-
process components for a specified system
To Return Execution Statistics
SQLSADISPLAY
on page 5-27 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
on page 5-30)
SQLCADISPLAY
on page 5-30 Writes error or warning messages from the SQLCA
structure to a file or terminal (superseded by
SQLCA_DISPLAY2_)
SQLCATOBUFFER
on
page 5-34
Writes error or warning messages from the SQLCA
structure to a record area (superseded by
SQLCA_TOBUFFER2_)