IBM MAINFRAME HELP & SUPPORT FORUMS

davidllw · Joined: 12 May 2005 Posts: 4 Location: China

Can we use DFSORT to search the dataset with a key word, and then replace it by the other word we specify?

i.e.

Input File A:
AAABBBCCDDDEEE
CCCAAABB
CEDCCC

run after the DFSORT coding

Ouput File B:
AAABBB11DDDEEE
111AAABB
1ED111

All 'CCC' change to '111'.

Thanks...
David

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

You say Quote: All 'CCC' change to '111'. but in your example of input and output you show EVERY 'C' replaced by '1'.

This DFSORT job will give you the output you show by replacing every 'C' with '1'. I've assumed your input file has RECFM=FB and LRECL=80, but you can change the job appropriately for other attributes.

Code:
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file (FB/80)
//SORTOUT DD DSN=... output file (FB/80)
//SYSIN DD *
OPTION COPY
* Set up ALTSEQ table for TRAN=ALTSEQ.
* X'C3' = 'C'. X'F1' = '1'.
ALTSEQ CODE=(C3F1)
* Use TRAN=ALTSEQ to change 'C' (X'C3') to '1' (X'F1').
OUTREC FIELDS=(1,80,TRAN=ALTSEQ)
/*

davidllw · Joined: 12 May 2005 Posts: 4 Location: China

Many Thanks...I'll try it tomorrow...:)

davidllw · Joined: 12 May 2005 Posts: 4 Location: China

Dear Frank,

I would like to ask one more stupid question. I never use the program highlight below. Is it still the DFSORT?

S1 EXEC PGM=ICEMAN

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

PGM=ICEMAN and PGM=SORT are ways to invoke the primary sort product at your site. If you have DFSORT as the primary sort product at your site, PGM=ICEMAN and PGM=SORT will invoke DFSORT.

davidllw · Joined: 12 May 2005 Posts: 4 Location: China

Frank, Thanks for your reply. I've tried your method. It do work. If I want to make a little change as follows. Can the DFSORT also solve it?

Change all 'C' to 'cat' and all 'B' to 'boys'. It means the length may extend.

i.e.
Input:
CAAAC
AACBBC

Output:
catAAAcat
AAcatboysboyscat

Regards,
David

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

DFSORT doesn't have any built-in functions for doing that kind of find and replace.

<It does as of July, 2008 - see my post later on>

mohitsaini · Joined: 15 May 2006 Posts: 41

hello,

Actually I am looking for a replacement for '$' with space (1 Byte only). How do I do that ???

Actually I was referring to the ASCII table for hex equivalent but it was of not help ...

Any kind of help would be really appreciated.

- Mohit

sril.krishy · Joined: 30 Jul 2005 Posts: 162 Location: hyderabad

Hi,
Try this.

Code:
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
AAA$BBCCDDDEEE
CCC$AABB
CED$CC
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
* SET UP ALTSEQ TABLE FOR TRAN=ALTSEQ.
* X'5B' = '$'. X'40' = blank.
ALTSEQ CODE=(5B40)
* USE TRAN=ALTSEQ TO CHANGE '$' (X'5B') TO ' ' (X'40').
OUTREC FIELDS=(1,80,TRAN=ALTSEQ)

your o/p will look like

Code:
AAA BBCCDDDEEE
CCC AABB
CED CC

Thank you
Krishy

mohitsaini · Joined: 15 May 2006 Posts: 41

Hi Krishy,

It is working now.

Thanks a ton but tell me one thing .... what table are you are referring to figure out '$' as 5B ...

As I mentioned in my previous message that I referred the ASCII table but couldn't find what you got and what you got is working fine ... so plz do tell me what table you are referring to ???

Thanks once again.

Mohit

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

Quote: As I mentioned in my previous message that I referred the ASCII table but couldn't find what you got and what you got is working fine ... so plz do tell me what table you are referring to ???

The ASCII and EBCDIC character sets are different. You need to look at the EBCDIC values for ALTSEQ. Here's a link to a table that shows the ASCII characters on the left and the EBCDIC characters on the right:

http://www.ncsa.uiuc.edu/UserInfo/Resources/Hardware/IBMp690/IBM/usr/share/man/info/en_US/xlf/html/lr425.HTM

If you go down the page on the right side, you'll see that blank is X'40' in EBCDIC and '$' is X'5B' in EBCDIC. So the ALTSEQ statement you need to change every '$' to a blank is:

Code:
ALTSEQ CODE=(5B40)

sril.krishy · Joined: 30 Jul 2005 Posts: 162 Location: hyderabad

Hi,
The simple thing that I do generally is,open any member in EDIT mode and type the letter which you want to convert.

Then use the HEX on function and see it's hex value and use that one in
ALTSEQ CODE.

When you type $0 and use the HEX on ,you can see the values like this.
54
b0

Thank you
Krishy

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4613 Location: San Jose, CA

Krishy,

Good suggestion. I often do that too.

vinoth_316 · Joined: 20 Jun 2006 Posts: 4

Hi all

I am new to Mainframes, I have a doubt similar to the question in this thread. I need to find out the low and high values in a file and replace them by space. Any help???

mohitsaini · Joined: 15 May 2006 Posts: 41

What if I want to replace two chars at a time

For example if I want to replace '$' with '0' (zero) and ' '(space) with '0'.

so the input file

abc$a888 9999

would look like:

abc0a88809999

How can we do this in just one step.

Rgds,
Mohit