SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-2
Procedure Descriptions
Procedure Descriptions
The following SQL procedures are described in alphabetical order on subsequent
pages. Each description includes the syntax, parameter definitions, and guidelines.
•
SQLCADISPLAY
•
SQLCAFSCODE
•
SQLCAGETINFOLIST
•
SQLCATOBUFFER
•
SQLGETCATALOGVERSION
•
SQLGETOBJECTVERSION
•
SQLGETSYSTEMVERSION
•
SQLSADISPLAY
SQLCADISPLAY
The SQLCADISPLAY procedure displays information that NonStop SQL returns to the
SQLCA data structure. SQLCADISPLAY writes this information to a file or terminal.
NonStop SQL communicates errors, warnings, and statistics to a program through the
SQLCA. However, because the SQLCA contains information in a format that is not
suitable to display, you must call the SQLCADISPLAY procedure to convert this
information to a suitable format.
The SQLCA information can be from these subsystems or system components:
•
NonStop SQL
•
FASTSORT program (SORTPROG process)
•
Sequential I/O (SIO) procedures
•
File system
•
NonStop Kernel operating system