Sample TPT Script; Loading Large Char FlatFile data to CLOB Datatypes

Tools & Utilities
Enthusiast

Sample TPT Script; Loading Large Char FlatFile data to CLOB Datatypes

Hello, I have a series of large flat files that are CSV, that contain very large blocks of character data larger than 8000 characters. I need to load to a Teradata Target table, empty at first, with a few of the columns using datatype CLOB. I'll be running TTU 14 off my PC, much like I do now with FLOAD and FEXP. Could someone kindly share with me a sample of TPT code that I could fashion much like my FLOAD scripts to handle loading this large character data to a CLOB datatype column with such a load utility? Please let me know what additional details you may need to know. Thanks! JPQ

1 REPLY

Re: Sample TPT Script; Loading Large Char FlatFile data to CLOB Datatypes