Page 1 of 1

Need JCL

PostPosted: Fri Sep 25, 2009 11:30 pm
by Nexus
Hi
am having the input in flat file like this

BP/MUFYI01/0409MUFYI012009040AMUFYI012009040B
BP/MUFYI02/0409MUFYI022009040AMUFYI022009040B
BP/MUFYI03/0409MUFYI032009040AMUFYI032009040B
BP/MUFYI04/0409MUFYI042009040AMUFYI042009040B
BP/MUFYI05/0409MUFYI052009040AMUFYI052009040B
BP/MUFYI06/0409MUFYI062009040AMUFYI062009040B
BP/MUFYI07/0409MUFYI072009040AMUFYI072009040B
BP/MUFYI08/0409MUFYI082009040AMUFYI082009040B
BP/MU/01PV/0408MU1PV040800000AMU1PV04080000B

and my output should be like this... I need to break the records like below mentioned

BP/MUFYI01/0409MUFYI012009040A
BP/MUFYI01/0409MUFYI012009040B
BP/MUFYI02/0409MUFYI022009040A
BP/MUFYI02/0409MUFYI022009040B
BP/MUFYI03/0409MUFYI032009040A
BP/MUFYI03/0409MUFYI032009040B
BP/MUFYI04/0409MUFYI042009040A
BP/MUFYI04/0409MUFYI042009040B
BP/MUFYI05/0409MUFYI052009040A
BP/MUFYI05/0409MUFYI052009040B
BP/MUFYI06/0409MUFYI062009040A
BP/MUFYI06/0409MUFYI062009040B
BP/MUFYI07/0409MUFYI072009040A
BP/MUFYI07/0409MUFYI072009040B
BP/MUFYI08/0409MUFYI082009040A
BP/MUFYI08/0409MUFYI082009040B
BP/MU/01PV/0408MU1PV040800000A
BP/MU/01PV/0408MU1PV040800000B

Can any one please help.. Thanks in advance :)

Re: Need JCL

PostPosted: Fri Sep 25, 2009 11:55 pm
by dick scherrer
Hello and welcome to the forum,

What do you want to execute in JCL. JCL alone cannot manipulate files. . . Only programs can. This would include utility programs such as the sort product in use on the system, file-aid, Easytrieve, etc.

You need to determine which tool of the ones available on your system you are going to use. You also need to post the "rules" for getting from the input to the output. Data examples are most helpful, but the rules also need to be posted. Also, menton the positions within the data of the relevant fields as well as the recfm and lrecl of the files.

If you learn nothing else new today, please learn that JCL can only execute programs. . . ;)

Re: Need JCL

PostPosted: Sat Sep 26, 2009 4:59 pm
by expat
Also, that is often considered impolite to just ask for code without showing the efforts you have made yourself.

Re: Need JCL

PostPosted: Sat Sep 26, 2009 5:42 pm
by MrSpock
expat wrote:Also, that is often considered impolite to just ask for code without showing the efforts you have made yourself.


...and to do it at least three times each under a different user id. And to keep bumping the post when it hasn't been responded to fast enough...