Need to change the Delimiter in file

rupesh gullu · New User Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon

Hi,

I have one job which creates one dynamic file and its a report. report has pipe as delimiter but now they want broken pipes to be its delimiter. I cannot change the program. Need to do it in JCL itself. Please help.

Regards,
rupesh

expat · Posted: Wed Dec 16, 2009 1:25 pm

When you ask for hekp, it would be appreciated if you could give us rather a lot more information that the "Less than basics" you have bothered to give us.

Now let me think about this, you want to change the output of a program but do not or can not change the program. Unless the program uses PARM or SYSIN values to accept information from the JCL then it ain't gonna happen.

enrico-sorichetti · Posted: Wed Dec 16, 2009 1:37 pm

look like the usual organization with a very poor change management process!

usually when people follow these approach it means that the change has not been approved
( or the end users are too lazy to follow ordinary practices )

if the report recipient has the need he must follow the proper procedures in order to implement the application change

much cheaper to change one little statement in a program than to add a step to the procedure

anyway depending on the sort product installed
searching for 'sort record reformatting" should give You a hint on how to proceed

rupesh gullu · New User Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon

Expat,

Parm which are passed to program are just date values. apart from this nothing is passed.

regards,
rupesh gupta

rupesh gullu · New User Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon

Enrico,

will 'sort record reformatting' work for dynamic files. I have no idea if sort works for dynamic files and moreover this is output file which is created by program. Program chages would have been much easier but they dont want to chage them.

regards,
rupesh

enrico-sorichetti · Posted: Wed Dec 16, 2009 1:46 pm

rupesh gullu · New User Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon

enrico,

just want to say that i have no idea if using sort utility i can change the delimiter to broken pipes. I can change the program but they dont want it.

Here is sample o/p of file which need to be changed.

enrico-sorichetti · Posted: Wed Dec 16, 2009 2:00 pm

the manuals will usually tell all You want to know...
looks like You did not care to do any search on You own

here is a link to the relevant DFSORT page
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ice1cg20/2.4?ACTION=MATCHES&REQUEST=reformat&TYPE=FUZZY&SHELF=ICE1SH20.bks&DT=20060615173822&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

if the records are fixed format it should not be that difficult

as I hinted before also search the forums for sort dfsort syncsort record reformatting

krisprems · Posted: Wed Dec 16, 2009 2:56 pm

here is an example where all the existence of '0' is replaced by '1' from position 1 up to 80 bytes. You can modify the sort card accordingly...

subhrm · New User Joined: 11 Jul 2008 Posts: 1 Location: India

1- First in the Job/PROC change the file name of the report((let's call it Rpt), in the step where it's currently created to a different name. (let's call it Work)

2- Add a new step . Here you can use DFSORT or a small program in any language to replace the charcater you want with desired one. In this step your input would be Work and output would be Rpt.

Hope this helps !!

dick scherrer · Posted: Wed Dec 16, 2009 10:03 pm

Hello,

If the file contains 100 records, making a copy is not a problem.

If the file contains several hundred million records (as many of mine do), creating an entire copy (only to prevent making a very simple code change) should be unacceptable. . .

If you make the code change, suggest the delimeter be stored external to the code - so when someone wants to change it again or change it back, no code change is necessary.

rupesh gullu · New User Joined: 12 Dec 2008 Posts: 96 Location: Gurgaon

Hi all,

thanks for your response. file was created successfully using below sort card