Hi,
I have a file which looks like one below:
Input file:
3448290001,824 ,106
3448290001,824 ,126
3448290001,824 ,182
I want my output file fields to be '~~' seperated instead of ','.
Expected Output file:
3448290001~~824~~106
3448290001~~824~~126
3448290001~~824~~182
How can I do this using SORT?
Please help me out!
O/P file fields to be '~~' seperated instead of ',' (Sort)
Moderators: Frank Yaeger, Moderator Group
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
If you're using SyncSort - what release of it you are using? You might try this:
Support for FINDREP was included in SyncSort for z/OS 1.3.2. If you are using DFsort, you might need the correct ptf to use FINDREP.
Code: Select all
//SYSIN DD *
OPTION COPY
INREC FINDREP=(IN=C',',OUT=C'~~')
/*
Support for FINDREP was included in SyncSort for z/OS 1.3.2. If you are using DFsort, you might need the correct ptf to use FINDREP.
Regards,
Anuj
Anuj
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
DFSORT's FINDREP function has been available since July, 2008. For more information on the associated PTF, see:
http://www.ibm.com/support/docview.wss? ... g3T7000085
http://www.ibm.com/support/docview.wss? ... g3T7000085
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
Thanks Anuj,
I used the following DFSORT for the same and its working fine:
I used the following DFSORT for the same and its working fine:
Code: Select all
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,10,
11:C'~~',
13:12,3,
16:C'~~',
18:17,3)
/*
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
That solution will only work if your fields are in fixed positions which you didn't mention.
FINDREP will work even if the fields are in variable positions. Here's an example of fields in variable positions delimited by commas.
In this case, only FINDREP will work.
FINDREP will work even if the fields are in variable positions. Here's an example of fields in variable positions delimited by commas.
Code: Select all
3448290001,824,106
0001,8,1
3448290001,82,18
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
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page