Issues with quotes during loading with bulk script

Pk39565 · Post by **Pk39565** » Wed Sep 29, 2010 10:46 pm

I have 2 sequential file which will load into a single table.One is created from server job and other is created from parallel job.Both will contain same type of data.

I am having no issue loading to a table (via sql loader (oracle)) from the file which is created from server job but file which is created from parallel job has issues in loading the following data.

"abc"|""""Gunnado""""|"def"

Sequntial File Format in Parallel Edition:
Pipe delimited
Null Filed Value=""
Quote="

Sequntial File Format in Server Edition:
Delimiter=|
Quote Character="

Please help me in solving this issue..thanks

chulett · Post by **chulett** » Wed Sep 29, 2010 10:58 pm

And the issue is?

Pk39565 · Post by **Pk39565** » Wed Sep 29, 2010 11:18 pm

Record is been rejected and the error is

"no terminator found after TERMINATED and ENCLOSED field"

chulett · Post by **chulett** » Thu Sep 30, 2010 5:24 am

And the example you posted:

"abc"|""""Gunnado""""|"def"

That is from the Server or PX generated file? What does the other one look like? Rather than assume, specificy for us which one loads and which one doesn't as well, please.