Re: SQLLDR fixed format and number format

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 19 Sep 2005 18:52:49 +0200
Message-ID: <dgmqd0$iu4$04$1@news.t-online.com>

Moritz Klein schrieb:
> Maxim Demenko schrieb:
>
>

>>Now i got it too, it seems, by using of 'G' + is not more optional, and 
>>by combination 'SG' all numbers must be signed. So, i would suggest use 
>>of only 'G' modifiers and ltrim all '+' signs (i.e.
>>open_int_change_prev position(138:147) 
>>"to_number(ltrim(:open_int_change_prev,'+'),'S99G999')" ).

>
>
> Shouldn't this be '99G999' because you eliminated all '+' signs?
>
>

>>Btw, if you would post the ddl of your table ( as well as your plattform 
>>and db version) , it would be easier to reproduce your problem, so you 
>>would increase the chance to get valuable response.

>
>
> Plattform:
> Windows Server 2003
> Oracle 10.1.0.3
>
> Thanks,
> Moritz

Yes, it was a typo, i meant '99G999', at least with this format mask i could load all records from your example, maybe it is not sufficient if this format don't cover all your records, anyway , i would have a close look on the .bad file after load.

Best regards

Maxim Received on Mon Sep 19 2005 - 11:52:49 CDT