17.10 - Load Data into or Export Data from the Database - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

After establishing a connection, load or export data from the database. Data can be loaded on a row by row basis using the PutRow function or as a block by using the PutBuffer function which is available to the Load, Update, and Stream drivers. Likewise, data can be exported one row at a time using the Export driver’s GetRow function or multiple rows can be exported together in a buffer using the Export driver’s GetBuffer function.

Data can be loaded into or exported from all of the columns in a table, or from a subset of the columns in a table. When loading data into a subset of the columns in a table, default values must be specified for the columns not being loaded. In each case, only the columns being loaded or exported from should be defined in the schema.

For example, Table1 has columns A, B, and C. Columns A and B are defined as integers and column C is a variable character column with a length of 25. To load data into column A only, a valid insert statement would be:

INSERT INTO Table1 (A, B, C) VALUES (:A, 0, NULL);

where zero is the default value for B and NULL is the default value for column C. The input schema for this example would be defined as only having column A.