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.
Turn a Tab Delimited File into a Fixed Width File
Re: Turn a Tab Delimited File into a Fixed Width File
by Frank Yaeger » Wed Dec 29, 2010 7:12 am
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
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
-
Frank Yaeger - Global moderator
- Posts: 1079
- Joined: Sat Jun 09, 2007 8:44 pm
- Has thanked: 0 time
- Been thanked: 15 times
Re: Turn a Tab Delimited File into a Fixed Width File
by 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?
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.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: Turn a Tab Delimited File into a Fixed Width File
by 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
Regards
Nic
- NicC
- Global moderator
- Posts: 3025
- Joined: Sun Jul 04, 2010 12:13 am
- Location: Pushing up the daisies (almost)
- Has thanked: 4 times
- Been thanked: 136 times
Re: Turn a Tab Delimited File into a Fixed Width File
by 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)
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
by 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,...)
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
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
-
Frank Yaeger - Global moderator
- Posts: 1079
- Joined: Sat Jun 09, 2007 8:44 pm
- Has thanked: 0 time
- Been thanked: 15 times
Re: Turn a Tab Delimited File into a Fixed Width File
by 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
Return to DFSORT/ICETOOL/ICEGENER
-
- Related topics
- Replies
- Views
- Last post
-
- Comma delimited to fixed width space delimited
by cbrio » Mon Aug 09, 2010 3:08 am - 3 Replies
- 7362 Views
- Last post by Frank Yaeger
Tue Aug 24, 2010 1:16 am
- Comma delimited to fixed width space delimited
-
- How to PARSE delimited file
by shankar_dh » Tue Jul 12, 2016 6:24 pm - 4 Replies
- 5692 Views
- Last post by BillyBoyo
Tue Jul 12, 2016 11:01 pm
- How to PARSE delimited file
-
- Incoming file, delimited, no line feed, spanning records?
by Peter J » Wed May 28, 2014 7:59 pm - 3 Replies
- 2403 Views
- Last post by Peter J
Wed May 28, 2014 10:44 pm
- Incoming file, delimited, no line feed, spanning records?
-
- Sort comma delimited data
by Subbarao » Mon Apr 07, 2014 1:17 pm - 4 Replies
- 6393 Views
- Last post by skolusu
Thu Apr 10, 2014 3:54 am
- Sort comma delimited data
-
- csv 2 fixed with non consistant amount fileds
1, 2, 3by AKDEARAGON » Fri Oct 07, 2011 12:08 am - 27 Replies
- 7346 Views
- Last post by skolusu
Fri Oct 14, 2011 5:03 am
- csv 2 fixed with non consistant amount fileds