ジョブのセットアップ - Access Module

Teradata® Tools and Utilities Access Moduleリファレンス

Product
Access Module
Release Number
17.10
Published
2021年10月
Language
日本語
Last Update
2021-11-16
dita:mapPath
ja-JP/uur1608578381725.ditamap
dita:ditavalPath
ja-JP/obe1474387269547.ditaval
dita:id
B035-2425
Product Category
Teradata Tools and Utilities
DEFINE JOB IMPORT_TO_TERADATA_SETUP
DESCRIPTION 'Import data to Teradata from GCS'
(
    STEP CLEANUP_CREATE_TABLE_STEP
    (
        APPLY
        (' DROP TABLE GCSW001 '),
        (' DROP TABLE GCSW001_e1 '),
        (' DROP TABLE GCSW001_e2 '),
        (' DROP TABLE GCSW001_log '),
        ('CT GCSW001
          (
              Associate_Id INTEGER,
              Associate_Name CHAR(25),
              Salary FLOAT,
              DOJ DATE,
              Designation VARCHAR(25),
              Loan_Amount DECIMAL(5,2),
              Martial_Status CHAR(1),
              No_Of_Dependents BYTEINT
          );
        ')
        TO OPERATOR ($DDL);
    );
);