Row Format - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
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.