Usage Notes
The Using Data Pointer Array field points to an array of using_data_ptr elements.
using_data_ptr_array is similar to using_data_ptr except that instead of pointing to an individual data item to be bound with the USING clause in the associated SQL request, it points to an array of data items. When the database receives the request it will iterate the statement represented by the SQL request by the number of times specified in using_data_count. Using this technique, an application that previously had to submit, 200 requests with the same SQL but different data items can accomplish the same thing with one request and 200 data items; this reduces network traffic considerably.
Language | Variable Name |
---|---|
COBOL: | DBCAREA-USING-DATA-PRT-ARRAY |
C: DBCAREA.H: | using_data_ptr_array |
Routine | Action Taken |
---|---|
DBCHINI: | writes |
DBCHCL: | reads (IRQ) |
Used by | Action Taken |
---|---|
application program | writes |
- using_data_count and using_data_ptr are both non-zero
- using_data_count is non-zero but using_data_ptr_array is zero
- using_data_ptr_array is non-zero and using_data_len_array is zero but var_len_req is set to 'N'
Error Code 502
CLI502 BADARRAYOPS: Invalid parameter combination for array-operations.