Create a Source Table - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide

Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
jth1645201817296.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2501
Product Category
Teradata Tools and Utilities
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.