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.