replacing a num/alphanumeric data using OVERLAY

sumit_mainframe123 · New User Joined: 06 Jul 2010 Posts: 4 Location: pune

Hi all,

I want to replace a existing numeric/alphanumeric data in a file. say replace 44 by 88.
I am using the below code:

SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=(1,2,ZD,EQ,'44')
OVERLAY=(1:'88'))

but there seems to be some problem with the syntax.
Kindly help me to get the solution.

rgds

expat · Posted: Wed Jul 07, 2010 6:48 pm

Found and adapted from a simple forum search.

Frank Yaeger · Posted: Wed Jul 07, 2010 10:03 pm

sumit_mainframe123,

For WHEN:

If you use ZD format, then you must use a decimal constant:

WHEN=(1,2,ZD,EQ,44)

If you want to use a character constant, then you must use CH format:

WHEN=(1,2,CH,EQ,C'44')

You cannot mix the two.

For OVERLAY, you can use a decimal constant or a character constant:

OVERLAY=(1:C'88')

or

OVERLAY=(1:+88,EDIT=(TT))

You can't just make up your own syntax and expect it to work. You have to look up the correct syntax in the DFSORT books which you can access from:

www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000080

sumit_mainframe123 · New User Joined: 06 Jul 2010 Posts: 4 Location: pune

Thanks alot for helping me!!!!

I'll keep the suggestions in my mind.