Writing the tpt Script - Teradata® Database

DEFINE JOB PRODUCT_SOURCE_LOAD

DESCRIPTION 'LOAD PRODUCT DEFINITION TABLE'
  (
    DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA
    DESCRIPTION 'PRODUCT INFORMATION SCHEMA'
      (
        TD_compatible_table_definition

      STEP STEP_CREATE_DDL
      (
        APPLY
        ('DROP TABLE '||@TargetTable||' ;'),
        ('CREATE MULTISET TABLE '||@TargetTable||'(TD_compatible_table_definition;')
      TO OPERATOR ($DDL() [1]);
  );
  Step Insert_Tables
  (
    APPLY
    ('Ins '||@TargetTable||'(
      :"column_name_1"
      ,:"column_name_2"
      [...,:"column_name_k"]
    );
  )
  TO OPERATOR ($LOAD()[1])

  SELECT * FROM OPERATOR ($ODBC(PRODUCT_SOURCE_SCHEMA)[1]);
  );
);