Hi
Im trying to read a file which was created as a part of a server version, and has to be read now in the parallel version.
At times i'm able to read the file, but when I run the job it gives me the below error.
For example:
Delimiter for field "MANDATE_INSTRUCTION" not found; input: {c7 e4 ca 20 e4 d5 c7 e4 cd 20 d4 d1 e3 c7 ca 20 d9 c8 cf c7 e4 e4 d7 ea e1 20 cc e5 ea e4 1 0 0 , 0 20 0 0 0 , 0 0 0}, at offset: 1468
there are around 91 fields in the file.
the format specified is
Final delimiter = end
delimiter = tab(the actual delimeter is comma)
null field value = \000
Quote = double
What i tried was -
1) tried changing the format(the one above)
2)when to table defn and did sync parallel
3) changed all the fields datatype to varchar
Thanks
File created in server, needs to be read in parallel job
Moderators: chulett, rschirm, roy
The short answer is the same regardless of the source: make the Parallel format specification match the actual file. The fact that it was created by a Server job shouldn't really matter. First question would be about this:
Why not use the "actual delimiter"? Did you? It's hard to tell from your post and it is complaining about the delimiter, after all.delimiter = tab(the actual delimeter is comma)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney