SQL/MP Programming Manual for COBOL
SQL/MP System Procedures
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
5-18
SQLCAGETINFOLIST
The information in the SQLCA structure can originate from these subsystems or 
system components: 
SQL/MP 
NonStop OS 
File system 
Disk process (DP2) 
FastSort program (SORTPROG process) 
Sequential I/O (SIO) procedures 
sqlca required input
is the record name of the SQLCA structure.
item-list required input
PIC X(length-of-table)
is a table of item codes that describes the information you want returned in the 
result buffer. For a list of these codes, see call-error
 output on page 5-20.
number-items required input
PIC S(9) COMP
is the number of items you specified in the item-list table.
result required output
PIC X(length-of-table)
is a table you define to receive the requested information. The items are returned 
in the order you specified in item-list. Each item is aligned on a word boundary.
Note. The SQLCAGETINFOLIST procedure returns error numbers as positive values and 
warning numbers as negative values. A program might need to switch the sign before 
processing the error or warning. 
ENTER TAL "SQLCAGETINFOLIST" USING
 sqlca,
 item-list,
 number-items,
 result,
 result-max, 
 [ error-index, ] 
 [ names-max, ]
 [ params-max, ]
 [ result-len, ]
 [ error-item ] 
 GIVING call-error.










