Re: Converting QM Query to rpg embedded SQL

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 2/22/2018 3:21 PM, Dan wrote:

> Do you have any links to yours or others that can be downloaded?  Google is
> not my friend.

The wiki has one:
https://wiki.midrange.com/index.php/SQL


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