All Forums Tools
13 Aug 2016
Understanding teradata sample scripts

Hi Guys,
I'm new to Terdata so trying to understand the sample/qstart programs in the Teradata dir. I was looking into the qstart1, and didn't understand where definition of the OPERATOR "$FILE_WRITER" or "$LOAD" was.
Can some one please help me with that.

dnoeth 4628 posts Joined 11/04
14 Aug 2016

You mean the scripts found in Teradata\Client...? Those are examples for TPT (Teradata Parallel Transporter).


Files in quickstart are based on the TPT Quick Start Guide and userguide scripts are based on the TPT User Guide.


Download those PDFs matching your TPT version at


feinholz 1234 posts Joined 05/08
15 Aug 2016

The $FILE_WRITER and $LOAD syntax describes the use of templates.
Those templates define the operators you are trying to use, and those operator definitions are found in the "templates" directory where TPT is installed.
You should see $FILE_WRITER.txt and $LOAD.txt files in that directory.


22 Aug 2016

Thanks that was really helpful.

You must sign in to leave a comment.