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

Create Table Procedure Syntax (EMPEXPT.SQ1)

This example shows the CREATE TABLE PROCEDURE syntax, stored in file EMPEXPT.SQ1. You can upload the syntax and store it in the CA IDMS system catalog.

*CREATE TABLE PROCEDURE STATEMENT FOR EMPLOYEE.EXPERTISE,EMPEXPT;

CREATE TABLE PROCEDURE EMPLOYEE.EXPERTISE

(DEPT_ID_0410        UNSIGNED NUMERIC(4,0),
 EMP_ID_0415         UNSIGNED NUMERIC(4,0),
 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),
 TOTAL_DOLLAR_AMT    DECIMAL(6,2),
 TRANS_DATE          DATE,
 TRANS_TIME          TIME)

EXTERNAL NAME EMPEXPT
GLOBAL WORK AREA 2048;
CREATE UNIQUE KEY EMPEXPT_KEY

ON EMPLOYEE.EXPERTISE
(DEPT_ID_0410        ,
EMP_ID_0415         );