Row Format - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.00
Published
September 30, 2020
Language
English (United States)
Last Update
2020-09-02
dita:mapPath
ups1544831946863.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

In each case, for z/OS and UNIX client systems, the columns to be selected are: Region, ProdCode, Quantity and Price.

The examples sort response data by Region and ProdCode and return it in indicator mode format. The response records are therefore defined in the same format as that for a row of the TranLogTable on the database, plus the leading indicator byte.

Each response row has 20 bytes, consisting of:
  • Indicator Flags: 1 byte
  • Region: 3 bytes
  • ProdCode: 8 bytes
  • Quantity: 4 bytes
  • Price: 4 bytes

In the OUTMOD examples, the FastExport utility passes each response record to a client procedure called ChkTran that modifies selected transaction records and notifies FastExport to either drop or to write each record to the client data set.

The Windows examples are presented differently.