Re: Converting QM Query to rpg embedded SQL

[Dan <dan27649@xxxxxxxxx>]

Vern,

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

Thanks,
- Dan

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.