15.00 - Create a Source Table - Parallel Transporter

Teradata Parallel Transporter Quick Start Guide

prodname
Parallel Transporter
vrm_release
15.00
category
User Guide
featnum
B035-2501-034K

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
    ATTR (
       TdpId=@SourceTdpId
      ,UserName=@SourceUserName
      ,UserPassword=@SourceUserPassword
    )
  );
);

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

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

tbuild -f qsetup2.txt -v jobvars2.txt -j qsetup2 

where:

 

This tbuild option...

Takes the following argument...

-f

Name of the script to be run: qsetup2.txt

-v

Name of the job variables file: jobvars2.txt

This is the job variables file you have edited.

-j

Name of the job: qsetup2

RESULT: 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.