Tech Trainings

SQL Loader – Control File Sample To Load Fixed Length Data File

December 9, 2020 by admin

Control File

OPTIONS (SKIP=1) 
LOAD DATA
INFILE '/home/applmgr/dataFiles/empData.dat'
append INTO TABLE emp
(
EMPNO   POSITION(01:04)   INTEGER EXTERNAL, 
ENAME    POSITION(05:14)   CHAR,
JOB      POSITION(15:24)   CHAR,
MGR      POSITION(25:28)   INTEGER EXTERNAL,
HIREDATE POSITION(29:39)   date "DD-MON-YYYY",
SAL      POSITION(41:44)   INTEGER EXTERNAL,
COMM     POSITION(46:47)   INTEGER EXTERNAL,
DEPTNO   POSITION(48:49)   INTEGER EXTERNAL
)

Data File

EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO
101 KING2     PRESIDENT     17-NOV-1981 5000 1 10

Comments |0|