Additional record in file on UNIX

vinaymanchinila · Post by **vinaymanchinila** » Mon May 16, 2005 11:14 am

Hi ,
I am extracting data from Oracle8i and writing to a flat file on UNIX. When I monitor the job it says "Finished, 117056 records writtten", but when I go to Unix and find out the word count (wc -l) it gives me 117057 , one record is totally blank(The file is loaded into SAP BW, and it is failing because of the balnk record).
Have no idea how it is getting generated and how do I spot it. If I restrict the job to 10,000 records I dont have this issue! it writes exactly 10K records and the word count is also 10K.

Thanks,

chulett · Post by **chulett** » Mon May 16, 2005 11:28 am

Try enabling the 'Omit last new-line' option in the Sequential File stage and see if that solves it for you.

Edit: I don't see how that jibes with the "If I restrict the job to 10,000 records I dont have this issue!" comment.

Still, curious to see if it helps.

vinaymanchinila · Post by **vinaymanchinila** » Mon May 16, 2005 11:30 am

We use the BW plug in stage which generates this flat file to be loaded in to SAP later on. So dont have the flat file options in this stage Craig!
Thanks,

chulett · Post by **chulett** » Mon May 16, 2005 11:55 am

Oh. Dang. Sorry, I was under the impression you were writing out directly to a flat file and then pushing the flat file up into SAP with the BW plug-in thing. I've got no clue how that works, never having had the pleasure of working with SAP and DataStage.

Hopefully someone can steer you in the right direction.

vinaymanchinila · Post by **vinaymanchinila** » Mon May 16, 2005 12:02 pm

I have downloaded the file and looked at it. There is one serial number which is giving the issue, it has "," in the values and it is bumping the other fields into next ones.
I did use TRIM(in.col3,",","") to replace the commas by space but looks like its not working.
If I extract expect for this value its fine!
Any help on what else it might be, I did check in SQL Plus, the value has looks normal expect that some have commas .
Thanks,