17.10 - Using Data Pointer Array - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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
Error code 502 is returned under the following circumstances:
  1. using_data_count and using_data_ptr are both non-zero
  2. using_data_count is non-zero but using_data_ptr_array is zero
  3. 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.