Midrange News for the IBM i Community

Posted by: neilrh
Jackson, MI
Resolved - OVRDBF and OPNQRYF broke
has no ratings.
Published: 17 Apr 2012
Revised: 23 Jan 2013 - 2246 days ago
Last viewed on: 19 Mar 2019 (7050 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Resolved - OVRDBF and OPNQRYF broke Published by: neilrh on 17 Apr 2012 view comments(8)

We have a lot of programs that were written way back when dinosaurs roamed the earth.  At that time the preferred method for reading a subset in a file was to OVRDBF file SHARE(*YES), OPNQRYF file SELECT('some records'), CALL rpgpgm.  The RPG program would process the selected records found in the shared open datapath opened by the OPNQRYF.

As of today (for us V7.1) this appears to be broken.  I can only assume it was caused by a recent PTF - and unfortunately our Admin is away for the rest of this week, so we don't currently know what he installed last weekend.

Anyone else encountering this problem?

and yes I know I could rewrite this using SQL, but there's a lot of 20+ yo programs that are using this technique.

Return to midrangenews.com home page.
Sort Ascend | Descend