Re: Converting QM Query to rpg embedded SQL

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.