Fwd: OS/400 V4R5 and OPNQRYF

[MacWheel99@xxxxxxx]

I appologize in advance if the pace of e-mail arrivals is such that I am 
asking a question someone else has already answered.

I knew that IBM had selected some programming languages & utilities to not 
get the benefit of enhancements to use the latest greatest stuff, but this is 
not a problem when we have millions of lines of ERP code working fine using 
stuff that IBM still supports in the form that it was originally written.  We 
just use whatever tools can support whatever we want to do, when developing 
enhancements & new programs.

Are you saying that OPNQRYF is in this category ... there will be new things 
we can do on the 400 starting with V5 but we won't be able to do them with 
OPNQRYF but our existing software investment will be secure?  We will also be 
able to use OPNQRYF for simple needs that have existed for the past 20 years 
& will continue to exist for some time to come.

I know that in theory "enhancements" can be made to data bases, such that 
they mean that some of the ways of accessing that data base are no longer 
functional, and we are then reminded that we need some kind of enhancement 
"audit" that works like the security audit.

I am thinking of upgrading security in a certain way, so we can run an audit 
to find out what software we are running that would break if we did that 
security upgrade & then work on fixing that software before doing the actual 
upgrade.

Some types of software enhancements might be like this ... I am thinking of 
adding this neat thing, but then run the enhancement audit (no such IBM 
product as far as I know) and get a list of what portions of the rest of our 
software would break if we did that.

I also knew about some great products & services IBM dropping entirely like 
M/36 & OV, in which large numbers of loyal customers had the IBM knife in the 
back, and future good will wounded seriously because of the hassle & expense 
of converting to some alternatives.

Are you saying that we are at risk of our applications suddenly broke due to 
OPNQRYF not supported in an OS/400 upgrade?  We are on BPCS 405 CD in which 
OPNQRYF is used all over the place tied to prompt screens ... user selects 
data range to be included in some inquiry or report & OPNQRYF gets what they 
need.  If this is what you are saying, then V4R5 would break BPCS 405 CD.

I also knew that some "enhancements" to OS/400 to "help" SQL effectively 
"broke" performance on some software using SQL heavily, so we had to get some 
PTFs to get 1/2 way back to the performance we used to have.  I think of this 
as the PC mentality contamination where corporate investment is sabotaged & 
you have to buy more hardware to keep your performance where it was.

Is this the kind of scenario you talking about?

I am supposed to be implementing V4R5 soon so I appreciate this thread opened 
to clarify the topic.

Thanks

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

---

• Subject: RE: OS/400 V4R5 and OPNQRYF
• From: "David Dunfield" <ddunfie@xxxxxxxxxxxx>
• Date: Fri, 23 Mar 2001 06:53:55 -0500
• Importance: Normal

I believe IBM has stated that there may be problems with opnqryf in the
beginning with the release following v5r1. At that time new data base
features will be added via sql and there are currently no plans to enhance
opnqryf to support the new database features added via sql.

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Bull, Jeff
Sent: Friday, March 23, 2001 6:01 AM
To: 'MIDRANGE-L@midrange.com'
Subject: OS/400 V4R5 and OPNQRYF


I have heard that there are potential problems in the pipeline for anyone
using OPNQRYF in there applications running under OS/400 v4r5; I understand
that this is (or may be) due to changes made by IBM.  Does anyone have more
information on this ?

Kind regards,
Jeff Bull.
Senior Support Consultant
Certified IBM AS/400 System Administrator
Midas Kapiti International Ltd

Tel:    44 (0) 175 370 8224
Fax:    44 (0) 175 357 0233
Mailto:Jeff.Bull@Midas-Kapiti.Com  << == Replies to
The views and opinions expressed in this e-mail are the senders own and do
not necessarily represent the views and opinions of Misys Plc.

This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named recipient
of this email then you should not copy it or use it for any purpose, nor
disclose its contents to any other person.  You should contact Midas-Kapiti
International as shown below so that we can take appropriate action at no
cost to yourself.

Midas-Kapiti International Ltd, Key West, 53-61 Windsor Road, Slough,
Berkshire, SL1 2DW, England
Email: Postmaster@midas-kapiti.com Tel: (44) 1753 573244 Fax: (44) 1753
570233
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

---