SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-10
SQLCAGETINFOLIST
resultmax input
INT
is the maximum size, in bytes, of the result structure.
errorindex input
INT
is the index of the SQLCA error or warning entry.
The SQLCA has a fixed set of fields (item codes 1–21) that pertain to all errors and
warnings. In addition, SQLCA has a table of records (item codes 22–29) with each
record describing one error or warning. NonStop SQL uses errorindex to access
this table to determine the error or warning
If errorindex is omitted, NonStop SQL returns the first error record.
namesmax input
INT
is the maximum length your program allows for procedure names or file names
(item codes 9, 13, and 19). Longer names are truncated (and no error results from
the truncation).
paramsmax input
INT
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).
resultlen output
INT .EXT
returns the total number of bytes used in the result structure.
erroritem output
INT .EXT
returns the index of the item being processed when the error occurred. The index
starts at 0.
Table 4-2 lists the codes you can specify in the itemlist array.