SQL Programming Manual for TAL

System Procedures
HP NonStop SQL Programming Manual for TAL—527887-001
4-11
SQLCAGETINFOLIST
Table 4-2. SQLCAGETINFOLIST Procedure Item Codes (page 1 of 2)
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 byte length of the name of the function in which the SQL
statement appears.
7 2 Actual byte length 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.
10 2 Syntax error location; if there was no syntax error, SQL returns –1.
11 2 Maximum byte length of the system procedure that sets the first
error or warning.
12 2 Actual byte length of the system procedure that sets the first error
or warning.
13 (in item
code 12)
Name of the system procedure that sets the first error or warning.
14 2 Maximum byte length of the parameter buffer.
15 2 Used bytes in the parameter buffer.
16 (in item
code 15)
Parameter buffer.
17 2 Maximum byte length of the source name buffer.
18 2 Used bytes in the source name buffer.
19 (in item
code 18)
Source name buffer.
20 4 Number of processed rows.
21 8 Estimated query cost.