Re: Opnqryf

[Booth Martin <booth@xxxxxxxxxxxx>]

(You may want a fixed font to view this)

It would be my guess that the opnqryf will do the job you ask.  Are you 
doing this in a CL?  A very useful thing I have done when getting messy 
results is this:

         OVRDBF     FILE(SomeFile) TOFILE(SomeFile) SHARE(*YES) 

         OPNQRYF    FILE((SomeFile)) QRYSLT(&SEL) + 

                      KEYFLD(INVDATE) 



         MONMSG     MSGID(CPF4174) 

         CPYFRMQRYF FROMOPNID(SomeFile) TOFILE(QTEMP/TestFile) + 

                      MBROPT(*ADD) CRTFILE(*YES) /* testing only */

Then do a runqry on the CPYFRMQRYF.  The data most likely will show 
where the error is ocurring.



steema@xxxxxxxxxxxxx wrote:
> HI I Have a file that is sorted by invoice number. The requirements for
> the reprt are to list details by year. Yet the date is not part of the
> key.
> I tried an OPNQRYF using the date as the key, but this was ignored.
>
> Did I do this wrong, or is there no way to do this w/out creating another
> logical?
>
> Thanks,
> Steve