CONNECT TO SAMPLE;
--SET CURRENT SCHEMA = '????????';
--
--DROP VIEW ALLEMPS;
--COMMIT;
--
  CREATE VIEW ALLEMPS AS
    SELECT EMPNO
         , FIRSTNME
         , MIDINIT
         , LASTNAME
         , WORKDEPT
         , PHONENO
         , HIREDATE
         , JOB
         , EDLEVEL
         , SEX
         , BIRTHDATE
         , DECIMAL(SALARY+BONUS+COMM,9,2) AS PAY
      FROM EMPLOYEE
    UNION ALL
    SELECT EMPNO
         , FIRSTNME
         , ' ' AS MIDINIT
         , LASTNAME
         , WORKDEPT
         , NULLIF(' ',' ') AS PHONENO
         , STARTDATE AS HIREDATE
         , NULLIF(' ',' ') AS JOB
         , NULLIF(SMALLINT(1),SMALLINT(1)) AS EDLEVEL
         , SEX
         , NULLIF(DATE('0001-1-1'),DATE('0001-1-1')) AS BIRTHDATE
         , DECIMAL(HRS_WORKED*HRLY_RATE,9,2) AS PAY
      FROM TEMP;
  COMMIT;
--
  SELECT *
    FROM ALLEMPS;
--
  CONNECT RESET;