The following is the job script you will be running:
DEFINE JOB qsetup1
(
APPLY
('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));')
TO OPERATOR ($DDL);
);
The script is saved as qsetup1.txt in the quickstart sample directory.
- To run the job script, execute the following Teradata PT command in the command window:
tbuild -f qsetup1.txt -v jobvars1.txt -j qsetup1
where the following is true:
- -f
- The name of the script to be run: qsetup1.txt.
- -v
- The name of the job variables file: jobvars1.txt.
- -j
- The name of the job: qsetup1.
Once you have run the tbuild command creating the 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.