SQL Programming Manual for Pascal

HP NonStop SQL Programming Manual for Pascal—528614-001

4-1

NonStop SQL System Procedures

Use the provided TAL system library procedures to perform various SQL functions.

These procedures are declared in the PEXTDECS file.

Table 4-1 describes the NonStop SQL system procedures by function. The

FILEINQUIRE procedure is described in the Guardian Procedure Calls Reference

Manual.

Table 4-1. NonStop SQL System Procedures (page1of2)

Displaying Errors and Warnings

Procedure Description

SQLCADISPLAY Writes to a file or to a terminal the error or warning

messages returned to the program by NonStop SQL.

SQLCATOBUFFER Writes to a record area in the program the error or

warning messages returned to the program by

NonStop SQL.

SQLCAFSCODE Returns information about the file system, disk

process, or NonStop Kernel operating system errors

returned to the program.

SQLCAGETINFOLIST Writes to a record area in the program a subset

(which you specify) of the error or warning information

in the SQLCA.

Displaying Execution Statistics

Procedure Description

SQLSADISPLAY Writes to a file or to a terminal the execution statistics

returned to the program by NonStop SQL.

Retrieving Version Information

Procedure Description

SQLGETCATALOGVERSION Returns a value that indicates the version of an SQL

catalog.

SQLGETOBJECTVERSION Returns a value that indicates the SQL object version.

This value represents the earliest SQL release that

can perform all DML and most DDL operations

defined for a given SQL table, index, or view.

SQLGETSYSTEMVERSION Returns a value that indicates the version of SQL file

system and disk process components on a given

system.