Create a Source and Target Table - Parallel Transporter

The following is the job script you will be running:

DEFINE JOB qsetup3
(
  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'');')
    ,('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));')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID01'',''JOHN'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID02'',''PETER'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID03'',''FRANK'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID04'',''MARY'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID05'',''ELLEN'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID06'',''MICHAEL'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID07'',''SAM'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID08'',''JONATHAN'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID09'',''MICHELLE'');')
    ,('INSERT INTO TARGET_EMP_TABLE(''ID10'',''ALICE'');')
  TO OPERATOR ($DDL);
);

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

For the purposes of this example, qsetup3 creates and populates both the source and target tables.

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

-f

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

-v

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

This is the job variables file you have edited

-j

The name of the job: qsetup3.

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