Create a Source Table

Teradata Parallel Transporter Quick Start Guide

brand
Teradata Tools and Utilities
prodname
Parallel Transporter
vrm_release
16.10
category
User Guide
featnum
B035-2501-057K
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
    ATTR (
       TdpId=@SourceTdpId
      ,UserName=@SourceUserName
      ,UserPassword=@SourceUserPassword
    )
  );
);

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 chapter of the Teradata Parallel Transporter Reference (B035-2436).