topic Re: Fixed record length in Application Development and Automation Discussions

Fixed record length

Former Member — Fri, 28 Sep 2007 16:55:26 GMT

Hi All,

I' am trying to write data into application server using Transfer statement.

Sometimes data would not be present in last fields, so the file length is varying.

How to have fixed file length?

regards,

Aravind

Re: Fixed record length

Former Member — Fri, 28 Sep 2007 17:00:35 GMT

Use LENGTH option of the TRANSFER statement.

Re: Fixed record length

Former Member — Mon, 01 Oct 2007 20:30:39 GMT

Hi Srinivas,

Even if I use 'Length' addition when I download the list, the record ends at the last character in the record. Is it how download works? When I do FTP ing whether it will work fine? If you have more info please pass it on to me.

Regards,

Aravind

Re: Fixed record length

Former Member — Mon, 01 Oct 2007 20:39:22 GMT

I guess thats how the OPEN and CLOSE dataset work. I assume it would be fine if you do a FTP or reuse it in any other prog.

Sri

Re: Fixed record length

Former Member — Tue, 02 Oct 2007 18:51:07 GMT

If you are downloading the file to application server with TRANSFER statement and LENGTH option, your spaces will be there at the end of the record. Just do not try to look at the file from within SAP environment (like using AL11). Try to get the file to your desktop and you can see that it will have those spaces.

If you using GUI_DOWNLOAD, then set the parameter TRUNC_TRAILING_BLANKS_EOL to SPACE (it is defaulted to 'X').