RE: opnqryf question - opnid, joins, overides, etc

[Carel Teijgeler <COTeijgeler@xxxxxxxxx>]

--
Rick,

I have another thought. You may try use Query Manager to generate an
outfile to be read in the RPG programme.
Although the client you are working for does not have SQL, you can create
an SQL-statement in a sourcefile and create a Query Manager Query
(CRTQMQRY) object with this source. The SRC PF should have a length of 91.
Without SQL loaded on the machine you can still use the query engine that
uses OPNQRYF.

The OPNID is only used to identify the Open Data Path created by the
OPNQRYF and can be used with some commands like POSDBF. It is not a
reference to an alias of the file, IIRC.

Just another look at the problem.

Regards,
Carel Teijgeler.

>This won't help, because you can specify the OPNID from which to copy.  If
>I CPYFRMQRYF, I get exactly the records I want, while the RPG reads all
>records.
>
>My problem is trying to get my rpg to recognize the override to the opnid,
>rather than the file.
>
>this, I guess, is what I'm looking for - the definitive answer - for an
>opnqryf join, does the file name in a RPG program HAVE to be overridden to
>the first file name of an opnqryf join?
>
>thanks again,
>
>Rick
--