Re: Using OPNQRYF issue with a missing key.

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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
>
>