Create a Target Table - Parallel Transporter

The following is the job script you will be running:

DEFINE JOB qsetup1

(

  APPLY

     ('DROP TABLE TARGET_EMP_TABLE;')

    ,('DROP TABLE TARGET_EMP_TABLE_LOG;')

    ,('DROP TABLE TARGET_EMP_TABLE_E1;')

    ,('DROP TABLE TARGET_EMP_TABLE_E2;')

    ,('CREATE TABLE TARGET_EMP_TABLE(EMP_ID VARCHAR(10), EMP_NAME VARCHAR(10));')

  TO OPERATOR ($DDL);

);

The script is saved as qsetup1.txt in the quickstart sample directory.

To run the job script that creates a target table, execute the following Teradata PT command in the command window:

tbuild -f qsetup1.txt -v jobvars1.txt -j qsetup1 

where:

This tbuild option...	Takes the following argument...
-f	Name of the script to be run: qsetup1.txt
-v	Name of the job variables file: jobvars1.txt This is the job variables file you have edited.
-j	Name of the job: qsetup1

RESULT: Once you have run the tbuild command creating the target table, you will see output on the console confirming that the table has been created. The console output may contain a DBS 3807 warning. You can ignore this message. For more information, see the ErrorList operator attribute in the DDL Operator chapter of the Teradata Parallel Transporter Reference.