Re: SQL*Loader and Implied decimals

Perform an operation on the data via the control file in dividing the data value by 10. Try it and see if it works for your situation:

load data
infile 'mcb.dat'
append
into table mcb
fields terminated by '~'
trailing nullcols
(testnum ":testnum/10")

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com

Jay Barbee <jybarb01!@homer.louisville.edu> wrote in article <3544a465.1042400602_at_netnews.louisville.edu>...
> Hello all...
>
> I have a flat file that I am trying to import via SQL*Loader. In this
> file there are two fields that contain decimals, but the actual
> decimal is not in the datafile itself.
>
> For example I am importing data that is 3 columns in lenght including
> one decimal place (3,1). So it should look like 12.3, but the file
> has it as 123! How do I tell Loader to expect xxx and turn that into
> xx.x?
>
> Thanks,
> --Jay
> Jay Barbee
> jybarb01!@homer.louisville.edu
> [ANTISPAM, remove "!" from address above...]
Received on Mon Apr 27 1998 - 15:31:47 CDT