--**********************************************************************00010000
--*  MEMBER NAME: TEMPTB                                               *00020000
--*                                                                    *00030000
--*  DESCRIPTION: CEJCO CLASS TEMPORARY TABLE SET-UP                   *00040000
--*                                                                    *00050000
--*  CHANGE ALL:  SCHEMA??     TO YOUR TABLE SCHEMA (CREATOR) NAME     *00060000
--*               CEJCO??      TO YOUR DATABASE NAME                   *00070000
--*               USERSPC1     TO YOUR TABLE SPACE NAME                *00080000
--*               CEJCOSG      TO YOUR STOGROUP NAME                   *00090000
--*               BP0          TO YOUR INDEX BUFFER POOL               *00100000
--**********************************************************************00110000
--                                                                      00120000
--DROP TABLE SCHEMA??.TEMP;                                             00130000
--COMMIT;                                                               00140000
--                                                                      00150000
  CREATE TABLE SCHEMA??.TEMP                                            00160000
    ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY                             00170000
    , FIRSTNME VARCHAR(12) NOT NULL                                     00180000
    , LASTNAME VARCHAR(15) NOT NULL                                     00190000
    , WORKDEPT CHAR(3)                                                  00200000
    , STARTDATE DATE                                                    00210000
    , SEX CHAR(1)                                                       00220000
    , HRLY_RATE DECIMAL(7,2)                                            00230000
    , HRS_WORKED INTEGER                                                00240000
    ) IN CEJCO??.USERSPC1;                                              00250000
  CREATE UNIQUE INDEX SCHEMA??.XTEMPPK                                  00260000
    ON SCHEMA??.TEMP                                                    00270000
    ( EMPNO    ASC )                                                    00280000
    USING STOGROUP CEJCOSG                                              00290000
          PRIQTY 12                                                     00300000
          ERASE NO                                                      00310000
    BUFFERPOOL BP0                                                      00320000
    CLOSE YES;                                                          00330000
  ALTER TABLE SCHEMA??.TEMP                                             00340000
    ADD PRIMARY KEY (EMPNO);                                            00350000
  COMMIT;                                                               00360000
--                                                                      00370000
  CREATE SYNONYM TEMP FOR SCHEMA??.TEMP;                                00380000
  COMMIT;                                                               00390000
--                                                                      00400000
  INSERT INTO TEMP                                                      00410000
    VALUES ('TEMP01','JOE'  ,'JONES','D11','1998-12-8','M',30. ,2080);  00420000
  INSERT INTO TEMP                                                      00430000
    VALUES ('TEMP02','JANE' ,'DOE'  ,'D21','1995-8-1' ,'F',150.,720);   00440000
  INSERT INTO TEMP                                                      00450000
    VALUES ('TEMP03','BETTY','SMITH','D11','1996-2-29','F',35. ,820);   00460000
  COMMIT;                                                               00470000
--                                                                      00480000
  SELECT *                                                              00490000
    FROM TEMP;                                                          00500000