Re: sqlloader and numeric fields

From: BHAVESH PATEL <BHAVESH-PATEL_at_worldnet.att.net>
Date: Thu, 23 Sep 1999 06:52:45 -0400
Message-ID: <7sd2or$nsj$1@bgtnsc02.worldnet.att.net>

Try to include the format for the field,

Who POSITION(51) CHAR "TO_NUMBER(:sal,'$99,999.99')", This might work.

-Bhavesh

nieuws net wrote in message <7scvog$elr$1_at_zonnetje.nl.uu.net>...
>hi everyone
>
>i have troubles with the sqlloader, the situation is :
>
>field who is defined in the database as number (5,2)
>
>in the input file i have that field defined as 00025.00 and in the control
>file
>i gave up the name off the field with decimal external but this doesn't
load
>the data.
>
>any one knows wich datatype i must use with the sql loader ?
>
>thanks
>
>gkor_at_rdw.nl
>
>
Received on Thu Sep 23 1999 - 05:52:45 CDT