File created in server, needs to be read in parallel job
Posted: Sun Jun 24, 2012 4:23 am
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
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