Using Data Pointer Array - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

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.