Re: sqlload control file
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/01
Message-ID: <55e2ie$2ja_at_newton.pacific.net.sg>#1/1
Date: 1996/11/01
Message-ID: <55e2ie$2ja_at_newton.pacific.net.sg>#1/1
Here is a sample control file for fixed positioning
<<<
LOAD DATA
INFILE abc.dat
INTO TABLE EMP (
EMP_NO POSITION(01:10) INTEGER EXTERNAL,
EMP_NAME POSITION(11:30) CHAR,
SALARY POSITION(31:39) INTEGER EXTERNAL )
>>>
If you need further assistance, refer to ORACLE Utilities Manual.
Hope the above info helps
Regards
N.Prabhakar
Socgen-Crosby Securities
Singapore.
Tel " (65) 390 2228 (office)
(65) 560 7785 (residence) Received on Fri Nov 01 1996 - 00:00:00 CET