NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-108
Examples—CONVERT
The EMPNUM field is converted to two columns named DEP_KEY and
EMP_KEY based on the elementary fields of the EMPNUM-KEY redefinition. The
column definitions in the CREATE TABLE command are:
DEP_KEY PIC X(2),
EMP_KEY PIC X(3),
The LOAD command in the SCHDCONV file contains the REDEFINE (EMP-
SCHEDULE.EMPNUM AS EMP-SCHEDULE.EMPNUM-KEY) option. The
CREATE TABLE command follows:
CREATE TABLE $VOL1.PERSNL.SCHEDULE
(
-- 02 EMP-SCHEDULE
-- 03 EMPNUM-KEY
-- 04 DEP-KEY
DEP_KEY PIC X(2) NOT NULL,
-- 04 EMP-KEY
EMP_KEY PIC X(3) NOT NULL,
-- 03 DAY-SCHED OCCURS 1/5 TIMES
-- 04 DAYNUM
DAYNUM_1 PIC X(2) NOT NULL,
-- 04 SHIFTS OCCURS 1/2 TIMES
-- 05 START-HOUR
START_HOUR_1_1 PIC 9(2) NOT NULL,
-- 05 END-HOUR
END_HOUR_1_1 PIC 9(2) NOT NULL,
-- 05 START-HOUR
START_HOUR_1_2 PIC 9(2) NOT NULL,
-- 05 END-HOUR
END_HOUR_1_2 PIC 9(2) NOT NULL,
...
DAYNUM_5 PIC X(2) NOT NULL,
-- 04 SHIFTS OCCURS 1/2 TIMES
-- 05 START-HOUR
START_HOUR_5_1 PIC 9(2) NOT NULL,
...