SQL/MP Programming Manual for COBOL

SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL529758-003
5-19
SQLCAGETINFOLIST
result-max required input
PIC S9(4) COMP
is the maximum size, in bytes, of the result table.
error-index optional input
PIC S9(4) COMP
is the index of the SQLCA error entry you want to see.
The SQLCA structure has a fixed set of fields (item codes 1 through 21) for errors
and warnings. In addition, SQLCA has a table of records (item codes 22 through
29), with each record describing one error or warning. SQL/MP uses
error-index to access this table to determine the error or warning.
If error-index is omitted, the first error record is returned.
names-max optional input
PIC S9(4) COMP
is the maximum length your program allows for procedure IDs or file names (item
codes 9, 13, and 19). Names that exceed this length are truncated (no error results
from the truncation).
params-max optional input
PIC S9(4) COMP
is the maximum length your program allows for parameter information (item codes
16 and 29). Parameter information that exceeds this length is truncated (no error
results from the truncation).
result-len optional output
PIC S9(4) COMP
returns the total number of bytes used in the result buffer.
error-item output
PIC S9(4) COMP
returns the index of the item being processed when the error occurred. The index
starts at 0.