Examples of DEFINE SCHEMA Statements - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

The following table lists examples of DEFINE SCHEMA statements.

Examples of DEFINE SCHEMA Statements
Example Statement Example
Example 1
DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA
   DESCRIPTION 'PRODUCT INFORMATION'
(
   PRODUCT_NAME                 VARCHAR(24),
   PRODUCT_CODE                 INTEGER,
   PRODUCT_DESCRIPTION          VARCHAR(512),
   PRODUCT_COST                 INTEGER,
   PRODUCT_PRICE                INTEGER,
   PRODUCT_WARRANTY             CLOB(50000),
   PRODUCT_PICTURE              BLOB (40000000) AS DEFERRED BY NAME
);
Example 2
DEFINE SCHEMA FREQ_FLYER_SRC
ADJUST UNICODE
DESCRIPTION 'SCHEMA FOR FREQUENT FLYER SOURCE FILE'
(
   RES_ID VARCHAR(14),
   FLIGHT_NO SMALLINT,
   ORIGIN CHAR(3),
   DEST CHAR(3),
   TKT_ID CHAR(12),
   TKT_ISSUE_DATE ANSIDATE,
   TKT_AMT DECIMAL(5,2),
   TRAVEL_AGCY_ID CHAR(4),
   FREQ_MILES_ID CHAR(8)
);
Example 3
DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA
DESCRIPTION 'PRODUCT INFORMATION'
(
   PRODUCT_CODE                INTEGER,
   PRODUCT_NAME                VARCHAR(24)   MACROCHARSET UNICODE,
   PRODUCT_DESCRIPTION         VARCHAR(512)  MACROCHARSET LATIN,
   PRODUCT_TYPE                CHAR(2)       MACROCHARSET KANJI,
   PRODUCT_COST                INTEGER,
   PRODUCT_PRICE               INTEGER
);
Example 4
DEFINE SCHEMA EMPLOYEE_SCHEMA
DESCRIPTION 'SAMPLE EMPLOYEE SCHEMA'
(
   EMP_ID      INTEGER,
   EMP_NAME    CHAR(30),
   EMP_DEPT    INTEGER,
   JOBDURATION PERIOD(DATE) USINGEXTENSION('AS VALIDTIME')
);
Example 5
DEFINE SCHEMA EMPLOYEE_SCHEMA
DESCRIPTION 'SAMPLE EMPLOYEE SCHEMA'
(
   EMP_ID       INTEGER,
   EMP_NAME     CHAR(30),
   EMP_DEPT     INTEGER,
   JOB_START    INTDATE,
   JOB_END      INTDATE USINGEXTENSION('PERIOD FOR JOBDURATION
                                     (JOB_START, JOB_END) AS VALIDTIME')
);
Example 6
DEFINE SCHEMA INVENTORY_SCHEMA1
DESCRIPTION 'SAMPLE INVENTORY SCHEMA'
(
   FILE_NAME    VARCHAR(30) METADATA(FILENAME),
   REC_NUMBER   BIGINT METADATA(FILERECORDNUMBER),
   ITEM_NUMBER  INTEGER,
   DESCRIPTION  VARCHAR(100),
   QUANTITY     INTEGER,
   PRICE        DECIMAL(6,2)
);
Example 7
DEFINE SCHEMA INVENTORY_SCHEMA2
DESCRIPTION 'SAMPLE INVENTORY SCHEMA'
(
   ITEM_NUMBER  INTEGER,
   DESCRIPTION  VARCHAR(100),
   QUANTITY     INTEGER,
   PRICE        DECIMAL(6,2),
   REC_NUMBER   INTEGER METADATA(FILERECORDNUMBER),
   FILE_NAME    CHAR(25) METADATA(FILENAME)
);