SQL Programming Manual for Pascal
NonStop SQL System Procedures
HP NonStop SQL Programming Manual for Pascal—528614-001
4-9
SQLCAGETINFOLIST
•
Disk process (DP2)
sqlca input
specifies the record name of the SQLCA from which information is to be retrieved.
itemlist input
is an array of item codes that describes the information you want returned in the 
result buffer. For a list of these item codes, see Table 4-2 on page 4-10.
number-items input
is the number of items you specified in itemlist.
result output
is a buffer you define to receive the requested information. The items are returned 
in the order you specified in itemlist. Each item is aligned on a word boundary.
result-max input
is the maximum size, in bytes, of the result buffer.
error-index input
is the index of the SQLCA error entry you want to see.
The SQLCA has a fixed set of fields (items 1-21 in Table 4-2), consisting of 
information that pertains equally to all the errors and warnings described. In 
addition, there is an array of records (items 22-29 in Table 4-2) in which each 
record describes one error or warning. SQL uses error-index to index into this 
array. error-index does not apply to the fixed fields.
If error-index is omitted, the first error record is returned.
FUNCTION SQLCAGETINFOLIST TAL EXTENSIBLE
(
 sqlca: EXTADDR;
 itemlist: EXTADDR;
 number-items: INTEGER;
 result: EXTADDR;
 result-max: INTEGER;
OPTIONAL error-index: INTEGER;
OPTIONAL names-max: INTEGER;
OPTIONAL params-max: INTEGER;
OPTIONAL result-len: EXTADDR;
OPTIONAL error-item: EXTADDR )
:INTEGER;










