Re: SQL*Loader and Implied decimals

From: Jay Barbee <jybarb01!_at_homer.louisville.edu>
Date: Tue, 28 Apr 1998 17:51:22 GMT
Message-ID: <35461495.1136655954@netnews.louisville.edu>

dewildeh_at_xs4all.nl (Henk de Wilde) wrote:

>On Mon, 27 Apr 1998 15:35:17 GMT, jybarb01!@homer.louisville.edu (Jay
>Barbee) wrote:
>
>>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?
>>
>According to the book (Utility's User Guide) implied decimal points
>have to be loaded by using a Sqlstring :
>
>NUM_1 position(1:3) decimal external ":NUM_1 / 10"
>

That worked just like a champ...

...thanks!

--Jay
Jay Barbee
jybarb01!@homer.louisville.edu
[ANTISPAM, remove "!" from address above...] Received on Tue Apr 28 1998 - 12:51:22 CDT