IBM Mainframe Forum

Hello,
I have a requirement as follows:

Input: File with three fields

Empid. Empname Mgrid.

Output:

Empid. Empname Mgrname

Explanation: Input file consists of three fileds, in which mgrid is the field which contains the Mgr info.
Same id is present in the empid too, so we have to retreive the name of that emp and have to be given as
Mgr name in the output field which has those particular values in the input.

Eg. I/p: 1 a 3 O/p: 1 a c
2 b 3 2 b c
3 c 3 3 c c

Input



Output



Can you have MGRIDs which are not EMPIDs, ie which are not on file? Do you have duplicate EMPIDs?

rahuil,

You need to do a better job of explaining what you want to do. Please show an example of the records in your input file (relevant fields only) and what you expect for output. Use ubb code tags! Show the actual values. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input file. If the file can have duplicates within it, show that in your example.

Sorry, I made a total mess of your data. Is it like this:




Managers being identified by empid = mgrid

And you want:


Can there be duplicate records on the file (as far as a key value is concerned)?

Can there be references to MGRID which are not on the file?

Can there be Managers who do not have employees?

Do you want the managers on the output file?

Hello billy,

Your second post matches with my requirement.

All ids shuld be in file, no duplicates for empid.

Can you post code for such requirement?

Get yourself familiar with the location of the DFSORT manuals, which are available on the web, and can be searched on the web or downloaded as PDFs.

It would be a JOINKEYS application that you need. This allows for the processing of file matching.

In your case, you want to match your input dataset "to itself". This at first seems odd, but hopefully you'll see what happens.

A very good source of sample code is the DFSORT forum here, there are also other such places on the web.

You can use a DFSORT job like the following to do what you asked for: