remove trailing spaces after/before FTP

sivatechdrive · Posted: Wed Jan 16, 2008 5:46 pm

Hi,

I am using a Fixed length file & it has single record... i want to remove the trailing spaces after/before the FTp step

ie when i FTp a file i am getting it as below
³AC³72268195³³³20080104³³³140015027~POC³000000955³QD³1³1³EA³³³VP³M56920~REF³ZZ³IA~CTT³1~SE³6³000200003~GE³3³20~IEA³1³000000112~-----------------------------------------------------------
(i represented blanks with

i am getting the spaces at the end, this is becoz the mainframe file is not fully occupied (the file is of length 150 but only 120 is occupied)...but i want to remove these trailing spaces after/before the FTP since in my notepad file the spaces are not accepted...

How to remove these trailing spaces in mainframes

Thanks n Regards
Prasad

Thanks n Regards
Prasad

expat · Posted: Wed Jan 16, 2008 5:49 pm

If the file is FB, and if the last 30 positions do not contain data, then they must contain spaces. What else is there to fill in those bytes.

guptae · Posted: Wed Jan 16, 2008 5:55 pm

Hi There,

U can copy these FILEA( length -150) to FILEB( length-120) by using below sort card & then ftp the FILEB

stodolas · Posted: Wed Jan 16, 2008 6:14 pm

Are you transferring to the mainframe? Then define your file to be the right size. Are you transferring from the mainframe? Then define your file to be the right size. Why are you padding 30 bytes at the end

superk · Posted: Wed Jan 16, 2008 6:22 pm

I think you can also do the opposite of this previous topic, which deals with retaining the spaces, not truncating them. I think you want to set TRAILingblanks FALSE.