DumpFieldsWithTrans set to Y produces the following output in the Teradata PT private log:
Record Number : 19 COL001 (ANSIDATE) 8660-11-01 COL003 (BYTEINT) 05 COL005 (CHAR(1)) S COL006 (CHAR(1)) T COL007 (CHAR(1)) U COL009 (DECIMAL(5,2)) -803.14 COL012 (INTEGER) -2147461379 COL015 (VARBYTE(5)) 00
The output shows:
- The record number
- The name of the field
- The data type of the field
- The field itself in ASCII format