SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-10
SQLCAGETINFOLIST
names-max input
is the maximum length your program will allow 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 input
is the maximum length your program will allow for parameter information (item
codes 16 and 29). Parameter information that exceeds this length will be truncated
(no error results from the truncation).
result-len output
returns the total number of bytes that were used in the result buffer.
error-item output
returns the index of the item that was being processed when the error occurred.
The index starts at 0.
SQLGETINFOLIST returns 0 if the operation is successful; otherwise,
SQLCAGETINFOLIST returns the NonStop Kernel operating system, file system, or
SQL error number.
Table 4-2 lists the item codes and describes them.
Table 4-2. SQLCAGETINFOLIST Procedure Item Codes (page 1 of 3)
Item
Code
Size (in
bytes) Description
1 2 SQLCA version.
2 2 Maximum number of errors or warnings the SQLCA can represent.
3 2 Actual number of errors or warnings.
4 2 Whether there were more errors or warnings than the SQLCA had
space to store:
0 there were no more errors or warnings
nonzero there were more errors or warnings
5 2 Whether there were more parameters than the SQLCA had space to
store:
0 there were no more parameters
nonzero there were more parameters
6 2 Maximum length, in bytes, of the name of the function in which the
SQL statement appears.
7 2 Actual length, in bytes, of the name of the function in which the SQL
statement appears.
8 (in item
code 7)
Name of the function in which the SQL statement appears.
9 4 Source code line number of the SQL statement that caused an error.