Home » RDBMS Server » Server Utilities » SQL loader problem
SQL loader problem [message #292795] |
Wed, 09 January 2008 21:10 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
I am loading data from csv to oracle.
I have attached the control file.
This file rejects
en017048,PD,N7C001013,cs,axp,usd,12202007,L,25.00,51.03,51.03,54.81,54.81,54.81,54.81,1370.14,1370.14,1370.14,1370.14,18.00,18.00,127 5.75,1275.75,-94.39,-94.39,-94.39,-94.39,0.00,0.00,usd,-94.39,-94.39,0.00,0.00,-94.39,-94.39,0.00,0.00
But reads
en017048,PD,N7C001054,ca,pgrxx,usd,12202007,L,,,,,,,,60.93,60.93,60.93,60.93,0.00,0.00,60.93,60.93,,,,,0.00,0.00,usd,,,,,,,,
when it rejects it says error that Error at column ltrepGL(last field) Invaild number.
Please advice.
[Updated on: Wed, 09 January 2008 21:17] Report message to a moderator
|
|
|
|
Re: SQL loader problem [message #292832 is a reply to message #292828] |
Thu, 10 January 2008 00:21 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
For the first doubt...no. I gave a sample only.
many records are rejected. similar to that...(all are having 0.00 at the last field)
I gave conatant 0.00 in control file...
Then it accepts all the rows...
I am new to this sqlloader. I am contnuing my friend's work.
As per my knowledge, if the sql loader finds number at the last field, it rejects.
|
|
|
|
|
|
Re: SQL loader problem [message #292871 is a reply to message #292868] |
Thu, 10 January 2008 01:47 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Ok.
I have all the fields in the table as per the control file.
the sql loader rejects the record if it finds any numeric data at the last.
Otherwise it accepts. Please refer the sample datas.
|
|
|
|
|
|
Re: SQL loader problem [message #292881 is a reply to message #292877] |
Thu, 10 January 2008 02:04 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
please read the note below that
"the bolded is just 0.00 . But while puuting here it becomes 0.
so I used comma for that."
while pasting it here, without comma...it will become zero.
To differentiate that, I have put comma.
Please note.
|
|
|
|
|
|
|
Re: SQL loader problem [message #293095 is a reply to message #292986] |
Thu, 10 January 2008 21:41 |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
rajavu1 wrote on Thu, 10 January 2008 18:49 |
No . Never , unless there is Error .
Rajuvan
|
Yes. It is working for other dates. For one particular date's records, it is rejecting. What would be the error?
The same data is accepted in the another one date.(last field with 0.00). Please advice.
[Updated on: Thu, 10 January 2008 21:44] Report message to a moderator
|
|
|
Re: SQL loader problem [message #293139 is a reply to message #293095] |
Fri, 11 January 2008 00:22 |
|
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
In the control fileQuote: | asOfDate DATE "MM/DD/YYYY"
| In the data it is 12202007.
Changing it to MMDDYYYY helps you? Have a try.
By
Vamsi
|
|
|
Goto Forum:
Current Time: Wed Nov 13 06:25:35 CST 2024
|