Create a Source Table | Teradata Parallel Transporter Quick Start Guide - Create a Source Table

The following is the job script you will be running:

DEFINE JOB qsetup2
(
  APPLY
     ('DROP TABLE SOURCE_EMP_TABLE;')
    ,('CREATE TABLE SOURCE_EMP_TABLE(EMP_ID VARCHAR(10), EMP_NAME VARCHAR(10));')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID11'',''BILLY'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID12'',''JANIE'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID13'',''KRYSTAL'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID14'',''MATTHEW'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID15'',''LINDA'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID16'',''DAN'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID17'',''LAINE'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID18'',''MICHIKO'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID19'',''WILL'');')
    ,('INSERT INTO SOURCE_EMP_TABLE(''ID20'',''MONICA'');')
  TO OPERATOR ($DDL);
);

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

To run the job script, execute the following Teradata PT command in the command window:
```
tbuild -f qsetup2.txt -v jobvars2.txt -j qsetup2
```
where the following is true:

-f

The name of the script to be run: qsetup2.txt.

-v

The name of the job variables file: jobvars2.txt.

This is the job variables file you have edited.

-j

The name of the job: qsetup2.

Once you have run the tbuild command creating the source 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" section of Teradata® Parallel Transporter Reference, B035-2436.

Create a Source Table | Teradata Parallel Transporter Quick Start Guide - Create a Source Table - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide - 20.00