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.