problem with wrapped rows

kirankota79 · Post by **kirankota79** » Mon Feb 05, 2007 8:45 am

Hi,

I have an issue with my data. I am getting a huge (1.5gb) datafile from mainframe box to unix machine and then from unix machine to windows machine where my datastage server is located. since we have some issues getting file from mainframe to windows (datastage) directly, we have include unix machine in the path.

So the thing is when i get the file, some rows in the file are wrapped in to 2 rows and unix is introducing the new line character while transferring to windows machine for the wrapped rows. I dont want that.

But we have tested a sample 12 record file that we got directly from mainframe box through email to windows and even the some rows are wrapped, it is not introducing the new line characters and the datastage is able to read it.

Can u please tell me the solution for it.

kota.

DSguru2B · Post by **DSguru2B** » Mon Feb 05, 2007 8:52 am

Get the file ftp'd in ASCII mode. This will ensure that the correct line terminator will be present for each platform.

kirankota79 · Post by **kirankota79** » Mon Feb 05, 2007 8:56 am

i have done that, but the problem is, it is introduing the CR/LF for the wrapped rows also. I tried both in ascii and binary mode. The rows are of fixed length of 3000 chracters. but the some rows are getting wrapped in to 2 rows with around 1500 characters each.

DSguru2B · Post by **DSguru2B** » Mon Feb 05, 2007 9:07 am

Is it just some rows displaying this behaviour or all the rows?

kirankota79 · Post by **kirankota79** » Mon Feb 05, 2007 9:09 am

only for some rows

DSguru2B · Post by **DSguru2B** » Mon Feb 05, 2007 9:12 am

Then that means you are having line feeds within your data. Report this back to the Mainframe folks.

timsmith_s · Post by **timsmith_s** » Mon Feb 05, 2007 9:12 am

Confirm that the field doent have nested cr/lf - might be a memo field or the like

kirankota79 · Post by **kirankota79** » Mon Feb 05, 2007 9:14 am

but, why i don't have this problem when i get the sample file directly from mainframe through e-mail?

DSguru2B · Post by **DSguru2B** » Mon Feb 05, 2007 9:25 am

Well then there must be something going wrong during the ftp. Are you sure your doing an ASCII ftp both from mainframe to unix and then from unix to windows.

timsmith_s · Post by **timsmith_s** » Mon Feb 05, 2007 9:12 pm

Are you transferring the file using NDM to do the transfer? Verify that it does not have a predefined line length.

timsmith_s · Post by **timsmith_s** » Mon Feb 05, 2007 9:19 pm

Favor - please explain the specific details of the file transfer. You are using native ftp? you are transfering the file as binary or ascii?

You might consider do a binary transfer and then using the UNIX tr comman to translate control-characters. Thoughts?