split each records in a file with out writing cobol program

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
ickgeek23
Member
Posts: 17
Joined: Tue Sep 13, 2011 7:57 am

split each records in a file with out writing cobol program

Post by ickgeek23 » Tue Sep 13, 2011 8:41 am

Hi to all,

I have one input file like

name1----------------------course1,course2,course3
name2----------------------course2,course3
name3----------------------

output file should be like
name1----------------------course1
name1----------------------course2
name1----------------------course3
name2----------------------course2
name2----------------------course3
name3----------------------

In this course name is of variable length (its length is not fixed), i need to solve with out writing any cobol program, i have to use some utility ..... Can anybody help me on this....


Thanks in advance

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Sep 13, 2011 10:27 am

Which sort product is used on your system?
Have a good one

ickgeek23
Member
Posts: 17
Joined: Tue Sep 13, 2011 7:57 am

Post by ickgeek23 » Tue Sep 13, 2011 11:16 am

we are using Syncsort

ickgeek23
Member
Posts: 17
Joined: Tue Sep 13, 2011 7:57 am

Post by ickgeek23 » Thu Sep 15, 2011 3:52 pm

Can anyone help me on this pls ......

MrSpock
Active Member
Posts: 273
Joined: Wed Jun 27, 2007 5:37 pm

Post by MrSpock » Thu Sep 15, 2011 5:08 pm

I don't think that the technical representitives from Syncsort have a presence on this forum. You'd probably get better results if you opened a support ticket with them directly.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Sep 15, 2011 9:16 pm

Thes can probably be done using PARSE with Syncsort.
Have a good one

ickgeek23
Member
Posts: 17
Joined: Tue Sep 13, 2011 7:57 am

Post by ickgeek23 » Fri Sep 16, 2011 12:44 am

Can you please help me how to do this with parse

Post Reply

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



Other References
Mainframe Tools and others