MIDRANGE dot COM Mailing List Archive



Home » BPCS-L » November 2002

Re: OPNQRYF problem



fixed

There is an easy way to test Danny's hypotheses; switch the order of the
SQLRPG and plain RPG after the OPNQRYF.

Also, there is a parameter in the OPNQRYF command which may help TYPE =
"Type of Open".  The associated help is below.

                            Open Query File (OPNQRYF)


..............................................................................

 :                         Type of open (TYPE) - Help
 :

 :  Specifies the level at which the Reclaim Resources (RCLRSC) command

 :  closes the file.

 :

 :      Note:  This parameter is ignored unless the default value is

 :      specified on the OPNSCOPE parameter and the request is from the

 :      default activation group.

 :

 :  The possible values are:

 :

 :  *NORMAL

 :      The Reclaim Resources (RCLRSC) command closes the file if the

 :      program call that ran this command is ended without closing the

 :      file.

 :

 :  *PERM

 :      The file remains open until the Close File (CLOF) command
closes it,
 :      or until the routing step or default activation group ends.
The
 :      query file remains open even if the Reclaim Resources (RCLRSC)

 :      command is run.



>>> dannym@agis-group.co.il 11/14/02 05:21AM >>>
[ Converted text/html to text/plain ]
hi
if you read the iim in seq mode (record after record until  lr )
then the 2nd pgm will get end of file
meaning u need to clof after the first pgm and do the opnqryf again for
the
2nd

Danny
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH 
IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL 
AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW.  If the reader of this message 
is not the intended recipient, or the employee or agent responsible for 
delivering the message to the intended recipient, you are hereby notified that 
any dissemination, distribution, copying, downloading, storing or forwarding of 
this communication is prohibited.  If you have received this communication in 
error, please notify us immediately via email and delete the message from your 
computer files and/or data base.  Thank you.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact