SQL Programming Manual for Pascal

NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-12
SQLCAGETINFOLIST
Table 4-3 lists the SQLCAGETINFOLIST error codes.
Example
In this example, SQLCAGETINFOLIST returns the:
•
Name of the procedure containing the SQL statement that produced one or more
errors or warnings
•
Name length of the function
•
Number of errors or warnings that occurred
•
Error code of the fifth error that was returned
CONST MAX_NAME_LEN = 30;
...
{ Declare a buffer to hold the error information: }
27 2 Sequence in which the error or warning was set.
28 2 Size of the buffer that contains parameters. Each string is delimited by
a zero.
29 (in item
code 28)
Buffer that contains parameters, delimited by a 0. Each parameter
begins on an even word boundary and is preceded by 2 bytes.
Table 4-3. SQLCAGETINFOLIST Procedure Error Codes
Error Code
Reason Function Failed
8510 Missing required parameter.
8511 Invalid item code.
8512 Supplied SQLCA is not a valid SQLCA structure.
8513 Supplied SQLCA release version is higher than the current executor
version.
8514 Insufficient buffer space.
8515 Error entry index is less than zero or is higher than the number of errors.
8516 The namesmax parameter was supplied with a value less than or equal to
zero.
8517 The paramsmax parameter was supplied with a value less than or equal to
zero.
Table 4-2. SQLCAGETINFOLIST Procedure Item Codes (page 3 of 3)
Item
Code
Size (in
bytes) Description