SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-14
SQLCATOBUFFER
1. Call SQLCAGETINFOLIST, passing item code 6 (maximum length of procedure
name)
2. Call SQLCAGETINFOLIST again, passing a buffer of the appropriate size.
SQLCATOBUFFER
The SQLCATOBUFFER procedure writes to a buffer the error or warning messages
that NonStop SQL returns to the application program. The buffer is a record area
declared in the variable declarations in the Pascal program. The messages 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
•
Disk process (DP2)
sqlca input
EXTADDR
is a pointer to the SQLCA structure, which is automatically declared when you
specify the INCLUDE SQLCA directive in the variable declarations part of the
program.
output-buffer input/output
FSTRING
specifies the record name to which SQLCATOBUFFER writes the error
information.
PROCEDURE SQLCATOBUFFER TAL EXTENSIBLE
( EXTREF sqlca: EXTADDR;
EXTREF VAR output-buffer: FSTRING;
OPTIONAL first-record-number: INT16;
OPTIONAL VAR output-records: INT16;
OPTIONAL VAR more: INT16;
OPTIONAL out-record-length: INT16;
OPTIONAL VAR sql-msg-file-number: INT16;
OPTIONAL errors: CHAR;
OPTIONAL warnings: CHAR;
OPTIONAL statistics: CHAR;
OPTIONAL caller-error-loc: CHAR;
OPTIONAL internal-error-loc: CHAR;
OPTIONAL EXTREF CONST prefix: FSTRING;
OPTIONAL EXTREF CONST suffix: FSTRING );