Page 2 of 2

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Wed Dec 29, 2010 7:12 am
by Frank Yaeger
Hmmm ... I don't have any problem getting to that page and nobody else has reported a problem to me.

Try downloading directly from the DFSORT ftp site:

ftp://ftp.software.ibm.com/storage/dfso ... rtpeug.pdf

If that doesn't work, senda note offline and I'll e-mail you back the
pdf file.

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Wed Dec 29, 2010 8:28 am
by dick scherrer
Hello,

When i click on the link Frank provided and then the .pdf link it works successfully.

Maybe your site prevents using FTP to download?

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Wed Dec 29, 2010 10:45 am
by NicC
I think your network is stopping you getting to that address. 2 things to try: 1- get your network personnel to alow you access to IBM's documentation, or, 2 - do it from home

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Wed Jan 05, 2011 5:55 pm
by hailashwin
Please use the below Sysin :

//SYSIN    DD    *                           
  OPTION COPY                                 
  OUTREC PARSE=(%01=(ENDBEFR=X'05',FIXLEN=9),
                %02=(ENDBEFR=X'05',FIXLEN=6),
                %03=(ENDBEFR=X'05',FIXLEN=6),
                %04=(ENDBEFR=X'05',FIXLEN=4),
                %05=(ENDBEFR=X'05',FIXLEN=4),
                %06=(ENDBEFR=X'05',FIXLEN=1),
                %07=(ENDBEFR=X'05',FIXLEN=7),
                %08=(ENDBEFR=X'05',FIXLEN=1),
                %09=(ENDBEFR=X'05',FIXLEN=2),
                %10=(ENDBEFR=X'05',FIXLEN=1),
                %11=(ENDBEFR=X'05',FIXLEN=1),
                %12=(ENDBEFR=X'05',FIXLEN=2),
                %13=(ENDBEFR=X'05',FIXLEN=4),
                %14=(ENDBEFR=X'05',FIXLEN=2),
                %15=(ENDBEFR=X'05',FIXLEN=1),
                %16=(ENDBEFR=X'05',FIXLEN=1),
                %17=(ENDBEFR=C'  ',FIXLEN=1)),
  BUILD=(%01,X,%02,X,%03,X,%04,X,%05,X,%06,X,%07,X,%08,X,%09,X,%10,X,
       %11,X,%12,X,%13,X,%14,X,%15,X,%16,X,%17)                   

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Thu Jan 06, 2011 12:25 am
by Frank Yaeger
Well, assuming you've got the FIXLEN correct for each field, you could increase each one by +1 and then you wouldn't need the Xs in the BUILD operand. For example:

 
   OUTREC PARSE=(%01=(ENDBEFR=X'05',FIXLEN=10),
             %02=(ENDBEFR=X'05',FIXLEN=7),
             %03=(ENDBEFR=X'05',FIXLEN=7),
   ...
   BUILD=(%01,%02,%03,...)

Re: Turn a Tab Delimited File into a Fixed Width File

PostPosted: Thu Jan 06, 2011 9:37 am
by hailashwin
Thanks Frank for the suggestion..