IBM Mainframe Forum

I have 2 PS files.

1. Keys file
2. PS file with some data

1. Keys file


2. Another PS file with some information. say file2

Requirement ?

We need to search the PS file with all the keys (field3) in the key file.

find, If any one of the key is presented in the file2 or not?
if presented, copy the file2 from disk to tape.

How would I fulfill this requirement?

NOTE: If one key found, copy dataset to tape. no need to check the remaining keys

Please help me out from this issue?

Thanks in Advance...

• JCL is not a programming language. It is used to prepare an environment that programs specified in the JCL can use when they run. That is all JCL can do.
• You are asking for the work product of professionals. Professionals expect to be paid. If you are willing to pay a professional to perform this task, leave a message here and someone may contact you using the private mail facility in this forum with their expected rates.

This is, basically, the same request as in the Rexx part of the forum. Do NOT multi-post either within the forum or across forums. Did you not read the forum rules?

Why don't yo guys suggest me with some strategy? I am not getting the way to do it.

"Hey guys, I want to skin a cat. Any ideas?"

But there is more than one way, so we need to narrow-down by what you are actually considering.

To do that, we need to know more about the task specifically, and more about the skills that you have available.

This could, for instance, be done by a language (Cobol, PL/I, Assembler even, whatever), rexx (another languague, left seperate for a reason), your Sort product. Other, obscure, ways.

If you want some ideas, provide some more information.

Good work with the Code tags, by the way. Thanks.

Nice nickname, but you have to work at it

You also have to remember it is the weekend so many people do not look on the forums as they may have a life to lead on Saturdays and Sundays. I don't - I am on holiday and life does not start until after 6pm.

BillyBoyo wrote:"Hey guys, I want to skin a cat. Any ideas?"

But there is more than one way, so we need to narrow-down by what you are actually considering.

To do that, we need to know more about the task specifically, and more about the skills that you have available.

This could, for instance, be done by a language (Cobol, PL/I, Assembler even, whatever), rexx (another languague, left seperate for a reason), your Sort product. Other, obscure, ways.

If you want some ideas, provide some more information.

Good work with the Code tags, by the way. Thanks.

Nice nickname, but you have to work at it

I would like to go with COBOL program, if it is going to help me out.

OK, so we need more information on the files.

We've seen the keys file, what about the 2nd file? There, is the key to search for in the same position each time, or are your searching "anywhere in the record/some part of the record"?

In the simplest case, you are searching in fixed position. Ensure that both files are sequenced on the keys for matching, and look at the "sticky" at the top of the Cobol forum here for matching two files.

For the more complex possibility, are the number of keys to search for limited in some way (is there a maximum number, actual or reasonable)? You'd store the keys in a table, read the second file, and then need some code to do the searching.

The "tape" part is just a thing in the JCL. You could do all your testing with disk datasets without invalidating anything, then do the final stuff with tape. z/OS has "device independence" which means that the JCL knows about tape/disk/whatever, your program doesn't need to know, it just knows it has a "file".

Get us some answers to the above and we see where to go next.

Hopefully when a moderator is around this topic can now be moved to the Cobol forum here.

JCLKINGBY2013 wrote:... I would like to go with COBOL program, if it is going to help me out.

Then it might make more sense to open this topic in the Cobol section of this forum. Don't expect people to write code for you; they won't. However, you may receive a suggestion that you should write pseudo code before you start writing a program, like this -Of course, you will need something similar to this for your copy code.

Now that wasn't so hard, was it?

And that's more than enough for nothing.

BillyBoyo wrote:OK, so we need more information on the files.

We've seen the keys file, what about the 2nd file? There, is the key to search for in the same position each time, or are your searching "anywhere in the record/some part of the record"?

In the simplest case, you are searching in fixed position. Ensure that both files are sequenced on the keys for matching, and look at the "sticky" at the top of the Cobol forum here for matching two files.

For the more complex possibility, are the number of keys to search for limited in some way (is there a maximum number, actual or reasonable)? You'd store the keys in a table, read the second file, and then need some code to do the searching.

The "tape" part is just a thing in the JCL. You could do all your testing with disk datasets without invalidating anything, then do the final stuff with tape. z/OS has "device independence" which means that the JCL knows about tape/disk/whatever, your program doesn't need to know, it just knows it has a "file".

Get us some answers to the above and we see where to go next.

Hopefully when a moderator is around this topic can now be moved to the Cobol forum here.

Billy and Steve-myers.....

I started working on this program.
1. Read the Key1 from keys file.
2. Read the 1st record from Flat file2.
3. I need to search the Key, anywhere in the flat file2 record.
4. Prepared code for Copying dataset.

I need to ful fill the 3rd step here...
Could you provide me with some suggestion???

Onemore thing, Is it okay to continue this topic in JCL forums or do I need to start as a new topic in COBOL forums???