SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-2
Procedure Descriptions
Procedure Descriptions
These NonStop SQL system procedures are described in this subsection. Each
description includes the syntax, parameter definitions, and guidelines.
•
SQLCADISPLAY
•
SQLCAFSCODE
•
SQLCAGETINFOLIST
•
SQLCATOBUFFER
•
SQLGETCATALOGVERSION
•
SQLGETOBJECTVERSION
•
SQLGETSYSTEMVERSION
•
SQLSADISPLAY
To use these procedures, specify the SOURCE directive for the appropriate procedure
declarations in the PEXTDECS file. Include the TYPES subsection to get the Pascal
TYPE definitions used in the declarations.
For example, this directive specifies declarations for the SQLCADISPLAY procedure:
IMPORT BEGIN
?SOURCE $SYSTEM.SYSTEM.PEXTDECS ( TYPES, SQLCADISPLAY )
END;
SQLCADISPLAY
The SQLCADISPLAY procedure displays error or warning messages that NonStop
SQL returns to the SQLCA data structure. SQLCADISPLAY writes the information to a
file or terminal.
The error or warning messages can be from these subsystems or system components:
•
NonStop SQL
•
FastSort program (SORTPROG process)
•
Sequential I/O (SIO) procedures
•
File system
•
The NonStop Kernel operating system
•
Disk process (DP2)
Determining the Catalog for a Table, Index, or View
Procedure Description
FILEINQUIRE (NonStop Kernel
operating system procedure)
Returns information about a file. The input codes 13
and 14 apply specifically to SQL objects.
Table 4-1. NonStop SQL System Procedures (page2of2)