Utilize Use Lists with DML Groups - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide - 17.20

Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
fag1645201363032.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2516
Product Category
Teradata Tools and Utilities

When the SQL statement(s) in a DML group are executed during the application process, there are cases when not all columns of data are needed. In such cases, it is wasteful to use all columns.

In Teradata PT, use lists allow the user to define which columns will be needed by the SQL statements in a DML group. The DMLGroup object has an AddUseList method which takes two arguments: the number of columns in the column set and a list of column names followed by a NULL value.

dmlGr->AddUseList(3, "Associate_Id", "Associate_Name", "Salary", NULL);

A DMLGroup object has a maximum of one use list. Columns can be added to this use list in one call or through a series of multiple calls to the AddUseList function. For example, three columns can be added to a use list in separate calls to the AddUseList function:

dmlGr->AddUseList(1, “Associate_Id”, NULL);
dmlGr->AddUseList(2, “Associate_Name”, “Salary”, NULL);

Or three columns can be added in the same call:

dmlGr->AddUseList(3, “Associate_Id”, “Associate_Name”, “Salary”, NULL);