JCL SORT question

pankaj1002 · New User Joined: 30 Jul 2012 Posts: 18 Location: India

I want to replace a certain string in one dataset with value taken from another dataset-

Dataset1:-
XXX@@@ P0000001 YYYYY
AAAAAAAAABBBBBBBBCCC
P0000001.XXXXXXXXXXXX

Dataset2:-
P000005

like in this example i need to replace all P0000001 in dataset1 to P000005 which it should read from Dataset2.

Probably SORT can do it but I need help urgently, thanks[/b]

Bill Woodger · Posted: Thu Oct 11, 2012 6:40 pm

Have a look at this.

enrico-sorichetti · Posted: Thu Oct 11, 2012 6:56 pm

or at this
www.ibmmainframes.com/viewtopic.php?t=59655&highlight=

pankaj1002 · New User Joined: 30 Jul 2012 Posts: 18 Location: India

[quote="enrico-sorichetti"]or at this
www.ibmmainframes.com/viewtopic.php?t=59655&highlight=

This example has fixed field position but in my requirement I need to Replace all that data wherever it is in the dataset and also retain all other rows.

enrico-sorichetti · Posted: Thu Oct 11, 2012 7:23 pm

while I agree that both links posted do not tackle the variable position,
as far as my link is concerned it would be enough to omit the include/exclude logic!

Akatsukami · Posted: Thu Oct 11, 2012 7:25 pm

It's too bad that you don't know COBOL or Rexx, Pankaj; it would a trivial thing to write a program in those languages to perform this task, instead of begging for sort control cards that you can't understand.

Bill Woodger · Posted: Thu Oct 11, 2012 7:31 pm

p@nk@j~,

Did you look at the other link at all?

If your data is variable as to its position, how about looking at how to use FINDREP? Which is "find" as in look for something in a position that does not have to be known and "replace" which means "replace". As long as you manage to get the arguments the same length, nothing else will "move" in your data.

Pandora-Box · Posted: Thu Oct 11, 2012 9:01 pm

p@nk@j~,

Do you know the strings to be replaced ?

What I mean to ask is

dick scherrer · Posted: Thu Oct 11, 2012 10:26 pm

Hello,

As has been mentioned, a public forum is not the best place for help if the issue is "urgent".

If you do need this so quickly, suggest you consider an implementation using something you know rather than trying to get someone to provide a Sort solution (or any other).

Which sort product is being used?

I believe you can do what you want using SYMNAMES and FINDREP if you intend to pursue the sort solution. There are many examples in the forum.