SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-2
COBOLEXT File
COBOLEXT File
To call the SQL/MP system procedures, which are written in TAL, use the COBOL
ENTER TAL statement. The COBOLEXT file contains source declarations for these
procedures (as well as for other system procedures). You might need to check with
your system administrator to make sure the COBOLEXT file for the procedures you
use in your program are available on your system. For more information about the
COBOLEXT file and the ENTER TAL statement, see the COBOL85 for NonStop
Systems Manual.
Guardian System Procedures
In addition to procedures in Table 5-1 on page 5-1, a COBOL program can also call the
Guardian system 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.
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 COBOL program opens and reads
the SQL message file when it calls an SQL system procedure that returns error or
status information (for example, SQLCA_DISPLAY2_ or SQLCA_TOBUFFER2_).
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_system
DEFINE. For the alternate SQL message files available on your node, ask your
database administrator or service provider.
You can add (or modify) the =_SQL_MSG_system DEFINE either interactively from
TACL or SQLCI or programmatically from a COBOL program:
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
number
FILE_GETINFOLIST_ Returns detailed information about a file using the file
number. Item codes 40, 82, 83, 84, and 85 apply to
SQL/MP
FILE_GETINFOLISTBYNAME_ Returns detailed information about a file using the file
name. Item codes 40, 82, 83, 84, and 85 apply to
SQL/MP