MVSFORUMS.com

lenovo · Posted: Wed Aug 31, 2011 1:48 pm Post subject: To update a file using SORT

Hi,
The requirement is to update a file using the contents of other.
For example
File 1 has the below contents:

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

Post a more complete example of the input files and the output you want when the process is run.
_________________
All the best,

di

lenovo · Posted: Wed Aug 31, 2011 2:37 pm Post subject:

Hi,

Hope I explain well this time. Apologies if I was not in the earlier case.

Input:
------
File 1 has below contents: size=80 bytes/FB

<some data> PART 12
<some data>

Here PART 12 starts from position 48. And there is only one PART in the whole file.

Output:
------
File 2 has below contents: size=80 bytes/FB

<static data>
PART 12
<static data>

Here PART 12 starts from 1st position in the third line. And there is only one PART in the whole file.

Only the number 12 after PART is changing. i.e. It could be 12/13/14/15.

Now, what I wants is that the utility should read file 1 and search PART and then pick the number after the PART
and then replace the part number in the second file.

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

lenovo,
Use code tags and please show few samples of Input records from both the file and expected output.

What do you mean by "there is only one PART in the whole file"? Did you mean only one PART value (i.e. part13,14,15 etc)?

What is the common key for both the files?

Thanks,

Frank Yaeger · Posted: Wed Aug 31, 2011 2:51 pm Post subject:

Lenovo,

If I understand correctly what you want, then a DFSORT job like the following will do it:

lenovo · Posted: Wed Aug 31, 2011 2:53 pm Post subject:

Hi All,
Thanks for the quick reponses.
@Frank:

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Alternatively you could try below...I have used XX in file1 to indicate any number.

lenovo · Posted: Wed Aug 31, 2011 3:49 pm Post subject:

Hi All,
@Frank: Thanks a million. It works fine.
@Sqlcode : Did not get a chance to to test this one. Thanks a lot for your efforts.

Your quick replies are really appreciated!!!

Frank Yaeger · Posted: Wed Aug 31, 2011 6:50 pm Post subject:

sqlcode,

As far as I can tell, that only works if every input file 2 record has PART in positions 1-4. But that doesn't match the OP's description of file 2 as:

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Frank,
Yeah, it wouldn't work.

As always thanks for correcting my mistake.

Thanks,

Nic Clouston · Posted: Sat Sep 03, 2011 7:03 am Post subject:

But..how do you audit these changes?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

papadi · Supermod Joined: 20 Oct 2009 Posts: 594 Topics: 1

Audit - we don' need no steenkin' audit. . .

Using this method, we can sneak anything we want info the file - and remove it later. . .

"Who knows what evil lurks in the hearts of men"

heh heh heh

di