Data file ulcase2.dat
--------------------
7782 CLARK MANAGER 7839 2572.50 10
7839 KING PRESIDENT 5500.00 10
7934 MILLER CLERK 7782 920.00 10
7566 JONES MANAGER 7839 3123.75 20
7499 ALLEN SALESMAN 7698 1600.00 300.00 30
7654 MARTIN SALESMAN 7698 1312.50 1400.00 30

Contril File
------------
LOAD DATA
INFILE 'ulcase2.dat'
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(32:39) DECIMAL EXTERNAL,
comm POSITION(41:48) DECIMAL EXTERNAL,
deptno POSITION(50:51) INTEGER EXTERNAL)


Data file generated dynamilcally and we have to load in Database, but we want some thing with this at the time of loading, we want some fixed value to be cancated with second column in each row.

like

7782 CLARK10001 MANAGER 7839 2572.50 10

where is 10001 is fixed, but I can't put this value in datafile at the time of file generation,

How to insert the value concated with second column.
can any body suggest.