home *** CD-ROM | disk | FTP | other *** search
- LOAD DATA
- INFILE case4.dat
- DISCARDFILE case4.dis
- DISCARDMAX 999
- REPLACE
- CONTINUEIF (1) = '*'
- INTO TABLE EMP
-
- ( EMPNO POSITION(01:04) INTEGER EXTERNAL,
- ENAME POSITION(06:15) CHAR,
- JOB POSITION(17:25) CHAR,
- MGR POSITION(27:30) INTEGER EXTERNAL,
- SAL POSITION(33:40) DECIMAL EXTERNAL,
- COMM POSITION(42:49) DECIMAL EXTERNAL,
- DEPTNO POSITION(51:52) INTEGER EXTERNAL,
- HIREDATE POSITION(53:61) INTEGER EXTERNAL)