RE: OS/400 V4R5 and OPNQRYF

|September 22, 2000) at
  03/23/2001 10:53:28 AM
MIME-Version: 1.0
Content-type: text/plain; charset=us-ascii
Sender: owner-midrange-l@midrange.com
Precedence: bulk
Reply-To: MIDRANGE-L@midrange.com
Errors-To: list-errors@midrange.com
X-List-Name: Midrange Systems Mailing List (MIDRANGE-L@midrange.com)


OPNQRYF (which by the way was developed as a  "IBM internal debugging tool"
for SQL) uses the same internal interface that SQL does.  IBM is cheapiong
out by only putting new function in SQL, and not in OPNQRYF and DDS.  My
own opinion says that they are wrong, but they don't necessarily listen to
me any way.

Al





                     rob@dekko.com 

                     Sent 
by:                   To:     MIDRANGE-L@midrange.com 

                     owner-midrange-l@mi        cc: 

                     drange.com                 Subject:     RE: OS/400 
V4R5 and OPNQRYF


                     03/23/01 09:09 
AM 

                     Please respond 
to 

                     MIDRANGE-L 








Request clarification.  Is it so much that there may be 'problems' with
existing OPNQRYF's, or, will it just not have any of the new function
available with SQL?  I would feel that it might be the latter.  But, as a
disclaimer, this information is strictly based on guess and not on any real
information and I am not implying I know or heard anything regarding this,
and there is NO winking emoticon after this disclaimer.
Of course I was pretty amazed that Lotus Enterprise Integrator, (formerly
known as Notes Pump), doesn't support transferring a blob from DB2 into a
rich text field.  Perfect example of where you'd want to use a blob.

Rob Berendt

==================
Remember the Cole!



                     "David Dunfield"

                     <ddunfie@net-link.n        To:
<MIDRANGE-L@midrange.com>
                     et>                        cc:

                     Sent by:                   Subject:     RE: OS/400 V4R5
and OPNQRYF
                     owner-midrange-l@mi

                     drange.com



                     03/23/01 06:53 AM

                     Please respond to

                     MIDRANGE-L







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
+---



+---
| 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
+---