• Subject: Re: Problem in OPNQRYF
  • From: "Joe Teff" <jteff19@xxxxxxx>
  • Date: Wed, 28 Jul 1999 15:07:53 -0500

>     Hi,
>        I am working on a V4R1 and i faced this queer problem.
>     These are following sequence of steps that i follow in a CLP:
>     1.Override the file with Share(*yes).
>     2.Do a OPNQRYF with a Query select expression.
>     3.Do a CPYFRMQRYF to a file in QTEMP which is not used anywhere.
>     4.Call a RPGILE program which reads the file used in OPNQRYF.
>
>     The problem is that when the RPG is called the file is already at EOF.
>     When the same thing is done with step 3 left out then the program
>     works fine. Is that a bug somewhere or am i missing something.

Use a statement like
         POSDBF     OPNID(your file) POSITION(*START)
after the CPYFRMQRYF and before you call your RPG program.
This will reset the file cursor to the beginning of the file.

Joe Teff

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].