|
Do you have any links to yours or others that can be downloaded? Google is
not my friend.
On Wed, Feb 21, 2018 at 8:37 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:
To expand a little on Lynne's explanation, it is possible to have a QMQRY
string like this - &Q1&Q2&Q3&Q4&Q5 - this would allow an SQL statement up
to 275 characters long, since each substitution variable can be at most 55
long. This is the basis of almost all the utilities people have made (Buck
Calabro had one I made a variation of, and others) that can run any SQL
statement, including SELECTs (IBM's RUNSQL does not directly run SELECT
statements). The statement is broken up into 55-character variables and
passed in the SETVAR parameter of STRQMQRY, which combines them into the
statement, as Lynne describes.
I have a presentation and lab I present at COMMON about QM - usually the
lab is all we put on the schedule these days.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
