Table Procedure Examples, Design, and Use › Sample Files › Create Table Syntax (EMPEXPT.SQ2)

Create Table Syntax (EMPEXPT.SQ2)

This is an example of the CREATE TABLE syntax, stored in file EMPEXPT.SQ2. You can load the table definition into an Ingres II database and use it to migrate and update data stored in a CA IDMS database.

*CREATE TABLE STATEMENT FOR EMPLOYEE.EXPERTISE,EMPEXPT;

CREATE TABLE EMPLOYEE.EXPERTISE

(DEPT_ID_0410        UNSIGNED NUMERIC(4,0) NOT NULL,
 EMP_ID_0415         UNSIGNED NUMERIC(4,0) NOT NULL,
 EXPERTISE_DAY       UNSIGNED NUMERIC(2,0),
 EXPERTISE_MONTH     UNSIGNED NUMERIC(2,0),
 EXPERTISE_YEAR      UNSIGNED NUMERIC(2,0),
 SKILL_ID_0455       UNSIGNED NUMERIC(4,0) NOT NULL,
 TOTAL_DOLLAR_AMT    DECIMAL(6,2),
 TRANS_DATE          DATE,
 TRANS_TIME          TIME);