Re: Opnqryf

[Dave Reiher/prairiefarms <DReiher@xxxxxxxxxxxxxxxx>]

I'll go along with Scott.
I just checked one of mine. I am doing OVRDBF SHARE(*YES) and in my 
OPNQRYF doing KEYFLD(FILE/DATEFLD) and it appears to be working.

    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx



SASchollenberger@xxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/22/2005 03:19 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Opnqryf






Did you do an OVRDBF SHARE(*YES) before the OPNQRYF command?
If not, the RPG (assuming here) program creates its own ODP rather than
using the one created
by OPNQRYF which applied your new ordering by date.
----------------------
Scott

Scott A. Schollenberger
Chief Technology Officer
TENEX Systems, Inc.
2011 Renaissance Blvd., Suite 100
King of Prussia, PA  19406
Phone: 610-239-9988  Ext. 305
Fax: 610-239-9995
E-mail: saschollenberger@xxxxxxxxxxxx
Web: www.tenexsys.com

IBM Certified Specialist - eServer i5 iSeries Technical Solutions
Implementer V5R3

CONFIDENTIALITY NOTICE:  This email message, including any attachments, is
for the sole use of the intended recipient(s) and contains confidential 
and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply email and destroy all copies of the original
message.

----------------------
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."    --Benjamin Franklin
----------------------


 
             steema@diskhaven. 
             com 
             Sent by:                                                   To 

             rpg400-l-bounces@         "RPG programming on the AS400 / 
             midrange.com              iSeries" <rpg400-l@xxxxxxxxxxxx> 
                                                                        cc 

 
             12/22/2005 03:46                                      Subject 

             PM                        Opnqryf 
 
 
             Please respond to 
              RPG programming 
              on the AS400 / 
                  iSeries 
             <rpg400-l@midrang 
                  e.com> 
 
 




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
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.