SQL/MP Programming Manual for C

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for C—429847-008
5-2
Guardian System Procedures
Guardian System Procedures
In addition to the procedures in Table 5-1 on page 5-1, a C program can also call the
Guardian procedures described in Table 5-2 to return information about SQL objects
and programs. For a detailed description of these procedures, see the Guardian
Procedure Calls Reference Manual.
cextdecs Header File
The cextdecs header file contains source declarations for the SQL/MP and Guardian
system procedures. Use the #include directive as shown in this example to copy the
declarations from the cextdecs header file for the procedures you want to call in your
program:
...
#include <cextdecs ( FILE_OPEN_, \
READ, \
WRITEREAD, \
FILE_GETINFO_, \
FILE_CLOSE_, \
SQLCADISPLAY, \
SQLCAFSCODE )> nolist
...
SQL Message File
The SQLMSG file contains error messages, informational messages, and help text
used by SQLCI, the SQL compiler, and host-language programs. The default SQL
message file is $SYSTEM.SYSTEM.SQLMSG. A C program opens and reads the SQL
message file when it calls an SQL system procedure that returns error or status
information (for example, SQLCADISPLAY or SQLCATOBUFFER).
The SQLMSG file contains text in English. You can specify a different SQL message
file (for example, a file translated into French) with the =_SQL_MSG_node DEFINE.
Table 5-2. Guardian System Procedures That Return SQL Information
Procedure Description
FILE_GETINFO_ Returns limited information, including the last error and
type, about a file using the file number.
FILE_GETINFOBYNAME_ Returns limited information about a file using the file
name.
FILE_GETINFOLIST__ Returns detailed information about a file using the file
number. Item codes 40, 82, 83, 84, and 85 apply to
NonStop SQL/MP.
FILE_GETINFOLISTBYNAME_ Returns detailed information about a file using the file
name. Item codes 40, 82, 83, 84, and 85 apply to
NonStop SQL/MP.