FormatFields - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
egk1499705348414.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

FormatFields set to a value of Y produces the following output in the Teradata PT private log:

Record Number: 19
Field1       0000       0000CAFE
Field2       0004       00000BAD
Field3       0008       5758595A
Field4       000C       32303030
Field5       0010       2D30312D 3031
Field6       0016       001B5465 72616461 7461

The output shows:

  • The record number
  • The name of the field
  • The hexadecimal offset of the field. For example, field2 starts with offset x'4' and field5 start with offset x'16'
  • The field itself in hexadecimal characters from the beginning of the field

FormatFields set to N produces the following output in the Teradata PT private log only if all “dump” attributes are set to N:

The output is identical to the output DumpFieldsNoTrans produces.
Record Number : 20
COL001      34 31 31 32 2D 30 32 2D 31 32
COL003      97
COL005      54
COL006      55
COL007      56
COL009      FF FE F5 CC
COL012      80 00 8C C0
COL015      00 01 00 30 20.

The output shows:

  • The record number
  • The column name
  • The field itself in hexadecimal characters from the beginning of the field.