Hi Folks, we are starting to use SQL more and more, going away from QRYDFN's. From an admin perspective, Is there a tutorial or docs or tip sheets, etc. that would give me info on how to secure SQL properly and to make it perform at optimum and to not slow down other system functions?
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Fri, Sep 14, 2012 10:13 pm
Subject: Re: From QRYDFN to SQL
Yes, I guess I mean that.
Now there is an interface to QM that can be very much like that of
uery/400 - STRQM - option 1 to work with queries has a prompted option,
here it is a lot like WRKQRY. Option 2 is for working with forms -
gain, it is a lot like Query/400 in its presentation options.
It still ends up creating a QMQRY, which is actually SQL. And
ventually, people might start to like using real SQL to specify the
You are able to do some security within this interface, too, so that
eople can only do SELECTs - others can be allowed to do any SQL
tatement allowed in an interactive kind of thing.
Worth a look, perhaps.
On 9/14/2012 12:47 PM, Jeff Crosby wrote:
I still strongly recommend using RTVQMQRY to move from QRYDFNs to using
SQL. It can even turn merge fields into substitution variables, which is
really cool, IMO.
I have read this suggestion from various sources many times over the
years. What we use Query/400 for is as an end user tool for queries.
We don't use Query/400 anywhere "in production" so to speak.
You're referring to "in production" use, correct?
VP Information Systems
P.O. Box 13369
Ft. Wayne, IN 46868-3369
The opinions expressed are my own and not necessarily the opinion of
my company. Unless I say so.