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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
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 Teradata 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 will be 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.