Re: Using OPNQRYF issue with a missing key.

Hi Darryl

You have to use SHARE(*YES), so that the called program can use the ODP - open data path - created by OPNQRYF.

Other than that, I don't know what is happening - seems about time to go with SQL in the RPG. Or create an SQL index with the same name as whatever is used in RPG, and maybe it can be an index over a JOIN VIEW and include the columns you want in it.

Thinking crazy I am!

Cheers
Vern

On 3/2/2020 2:41 PM, dfreinkel wrote:

I have an issue where there is a CL program with an OPNQRYF using
SHARE(*YES) on a JOIN LF.


I had to change the program from SHARE(*YES) to SHARE(*NO) only to find that
the keys on the OPNQRYF are different to the keys defined in the DDS of the
JOIN file. The SHARE(*YES) allows this or did allow it until another
modification came through when the RPG program crashed on loading the RPG.


The keys defined in the join LF are:

* Key 1 (both files)
* Key 2 (second file only)
* Key 3 (both files)


The OPNQRYF keys are as follows:


File1.Key1

File2.Key2

File1.Key3



Can this be achieved in defining the join LF?


TIA


Darryl Freinkel

A4G.

Tel: 770.321.8562 Ext 111 | Cell: 678.355.8562