SQl Loader 305 Error
From: <kasthuri_at_viisage.com>
Date: 2000/06/30
Message-ID: <8jie90$c7k$1_at_nnrp1.deja.com>#1/1
[Quoted] [Quoted] (:contrib_amt,1,length(:contrib_amt)-3)||'.'||substr(:contrib_amt,length
(:contrib_amt)-3,2)),to_number(
substr(:contrib_amt,1,length(:contrib_amt)-3)||'.'||substr
(:contrib_amt,length(:contrib_amt)-3,2)))"
Date: 2000/06/30
Message-ID: <8jie90$c7k$1_at_nnrp1.deja.com>#1/1
[Quoted] Hi All,
[Quoted] I have an amt column in my table which is NUMBER(11,2). The input data [Quoted] contains a trailing negative sign and doesnt contain decimal points. i [Quoted] have something like this in my control file. But i get an error saying [Quoted] that the token is longer than allowable 258 char. I dont know how i can [Quoted] further reduce it. Is there any other way of doing it? [Quoted] Any suggestions would help.
Control file:
contrib_amt POSITION(21:35) DECIMAL EXTERNAL "decode
(substr(:contrib_amt,length(:contrib_amt)),'-',-to_number(substr
[Quoted] [Quoted] (:contrib_amt,1,length(:contrib_amt)-3)||'.'||substr(:contrib_amt,length
(:contrib_amt)-3,2)),to_number(
substr(:contrib_amt,1,length(:contrib_amt)-3)||'.'||substr
(:contrib_amt,length(:contrib_amt)-3,2)))"
- I tried with Zoned also. it didnt work. gave me an 'invalid zoned decimal nibble'
Thanks & Regards
J.Kasthuri
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jun 30 2000 - 00:00:00 CEST