SQL Statements › CREATE TABLE › Data Types › Example 3

Example 3

Create a table with the following specifications:

1. Authorization ID: JOE
2. Table name: PROJECTTBL
3. Column names (CHARACTER data): PROJECTNUM (value to be unique), PROJECTNAME (value to be unique), DEPTNO, EMPNUM, MAJPROJECT
4. Column names (DECIMAL data): PROJSTAFF, PRSTARTDATE, PRENDDATE

   EXEC SQL
         CREATE TABLE JOE.PROJECTTBL
              (PROJECTNUM CHAR(6) NOT NULL UNIQUE,
               PROJECTNAME CHAR(24) NOT NULL UNIQUE,
               DEPTNO CHAR(3),
               EMPNUM CHAR(6),
               PROJSTAFF DECIMAL(5,2),
               PRSTARTDATE DECIMAL(6),
               PRENDDATE DECIMAL(6),
               MAJPROJECT CHAR(6))
   END-EXEC