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.