
Appendix B. Database generation samples 563
LOAD DATA INDDN(SYSRECDP)
INTO TABLE DAVINR1.DEPT
(DEPTNO POSITION( 1) CHAR(3),
DEPTNAME POSITION( 5) vaRCHAR,
MGRNO POSITION(37) CHAR(6) NULLIF(MGRNO=' '),
ADMRDEPT POSITION(44) CHAR(3),
LOCATION POSITION(48) CHAR(16))
ENFORCE NO
LOAD DATA INDDN(SYSRECEM) CONTINUEIF(72:72)='X'
INTO TABLE DAVINR1.EMP
(EMPNO POSITION( 1) CHAR(6),
FIRSTNME POSITION( 8) vaRCHAR,
MIDINIT POSITION(21) CHAR(1),
LASTNAME POSITION(23) vaRCHAR,
WORKDEPT POSITION(36) CHAR(3),
PHONENO POSITION(40) CHAR(4),
HIREDATE POSITION(45) DATE EXTERNAL,
JOB POSITION(56) CHAR(8),
EDLEVEL POSITION(65) INTEGER EXTER ...