Turn a Tab Delimited File into a Fixed Width File



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

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

Postby Frank Yaeger » Wed Dec 29, 2010 7:12 am

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

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

 

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

Postby dick scherrer » Wed Dec 29, 2010 8:28 am

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

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

Postby NicC » Wed Dec 29, 2010 10:45 am

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
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

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

Postby hailashwin » Wed Jan 05, 2011 5:55 pm

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)                   
hailashwin
 
Posts: 5
Joined: Wed Jan 05, 2011 5:49 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby Frank Yaeger » Thu Jan 06, 2011 12:25 am

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,...)
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

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

Postby hailashwin » Thu Jan 06, 2011 9:37 am

Thanks Frank for the suggestion..
hailashwin
 
Posts: 5
Joined: Wed Jan 05, 2011 5:49 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post