SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-11
SQLCAGETINFOLIST
10 2 Syntax error location; if there was no syntax error, SQL returns –1.
11 2 Maximum length, in bytes, of the system procedure that sets the first
error or warning.
12 2 Actual length, in bytes, of the system procedure that sets the first error
or warning.
13 (in item
code 12)
Location of the system procedure that sets the first error or warning.
14 2 Maximum length, in bytes, of the parameter buffer.
15 2 Used bytes in the parameter buffer.
16 (in item
code 15)
Parameter buffer.
17 2 Maximum length, in bytes, of the source name buffer.
18 2 Bytes used in the source name buffer.
19 (in item
code 18)
Source name buffer.
20 4 Number of processed rows.
21 8 Estimated query cost.
22 2 SQL error or warning number.
23 2 Subsystem ID:
First byte is 0
Second byte:
S Compiler, catalog manager, executor, SQLUTIL, SQLCI
F SQL file system
D DP2 disk process
G NonStop Kernel operating system
R FASTSORT (SORTPROG process)
L Load routines
I SIO procedures
24 2 Suppress printing this error:
nonzero True
0 False
25 2 Offset into the parameters buffer for parameters associated with the
call. SQL returns –1 if there are no parameters.
26 2 Number of parameters for this error.
Table 4-2. SQLCAGETINFOLIST Procedure Item Codes (page 2 of 3)
Item
Code
Size (in
bytes) Description