OPNQRYF qryslt parameter

[Guest.Visitor]

The qryslt is without doubt the most troublesome parm in all of the 400 commands.. On the other hand the "where" clause of the SQL select command is generally easy to understand and use. Here is a challenge for you A-#1 Super JOE programmers out there..Write a program that will take a SELECT statement and produce the equivalent OPNQRYF command... <HR>...... <pre> <H4>Bob Hamilton TEXAS BUSINESS SYSTEMS 736 Pinehurst Richardson, Texas 75080 <h4> </pre></h4></h4>

[David Abramowitz]

On Saturday, March 27, 1999, 02:38 AM, Bob Hamilton wrote: The qryslt is without doubt the most troublesome parm in all of the 400 commands.. On the other hand the "where" clause of the SQL select command is generally easy to understand and use. Here is a challenge for you A-#1 Super JOE programmers out there.. Write a program that will take a SELECT statement and produce the equivalent OPNQRYF command... <hr> All query functions on the AS/400 call. or use the QQQUERY program in some fashion. The bottom line here, may not necessarily be to transfer one type of query into another, but rather to find the most efficient method. So.... Let's take your concept one step further. The task would now be to take any form of AS/400 query (QM, QRY/400 OPNQRYF, SQL, FMTDTA, etc.) and translate it to a call to QQQUERY. Once this is done, it may be easier to find any inefficiencies, and correct them. David Abramowitz

[Guest.Visitor]

Well how about some standardization between these query products?.. %SST, %SUBSTR, SUBSTR, *NE, <>, NOT =, etc. It's very frustrating when you can't interchange selection criteria easily. Not to mention the various third party products. <hr> <font color="blue"> On Saturday, March 27, 1999, 03:50 AM, David Abramowitz wrote: On Saturday, March 27, 1999, 02:38 AM, Bob Hamilton wrote: The qryslt is without doubt the most troublesome parm in all of the 400 commands.. On the other hand the "where" clause of the SQL select command is generally easy to understand and use. Here is a challenge for you A-#1 Super JOE programmers out there.. Write a program that will take a SELECT statement and produce the equivalent OPNQRYF command... <hr> All query functions on the AS/400 call. or use the QQQUERY program in some fashion. The bottom line here, may not necessarily be to transfer one type of query into another, but rather to find the most efficient method. So.... Let's take your concept one step further. The task would now be to take any form of AS/400 query (QM, QRY/400 OPNQRYF, SQL, FMTDTA, etc.) and translate it to a call to QQQUERY. Once this is done, it may be easier to find any inefficiencies, and correct them. David Abramowitz </font>