Re: SQL*loader negative numbers

I can think of two solutions.

1. Import the field as a character field. Then after the import, run a query with a decode statement to multlipy by -1 if appropriate and then save the result in another column.
2. In your sql*loader control file, you will need to split up the load with a WHEN clause to test for the '-' in the number field.

On Fri, 7 Feb 1997 08:39:26 GMT, smp <> wrote:

>I posted this in cdo.servers, but no luck with responses yet so sorry if
>you've read this already.
>I'm trying to load data using SQL*loader but can't find how to load signed
>numbers. The fields may or may not be signed eg 1234 or 1234-, so I can't put
>in a 'multiply by -1' . I've looked in the Utilities manual but can't work out
>how to describe the field in the control file (integer external? decimal
>external??) Any pointers would be greatly appreciated.
>TIA
>
>Sally Pearce
>Financials DBA(for my sins)
Received on Sun Feb 09 1997 - 00:00:00 CET