Re: Converting QM Query to rpg embedded SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

On one thought I find I don't agree - I know that the general-purpose 
SQL processor I built was not to get around not being able to do 
embedded SQL, since we always had that capability wherever I was.

My purpose was to do SQL at a command line, and especially to get ad hoc 
reports easily. It wasn't meant to return anything to the program using 
the command. The latter is a nice feature, of course.

IBM's RUNSQL gives us the ability to do any statement other than SELECT 
- the various QM-based commands let us do SELECTs as well as DDL 
functions like INSERT and the various CREATEs, etc. And I've thought 
that using CREATE TABLE with a SELECT doesn't make it if what I want is 
a display of data or a report of it.

And the reporting ability and output options of STRQMQRY are a part of a 
more complete version of these utilities, some capabilities that IBM's 
RUNSQL can't do, either.

Regards
Vern

On 2/22/2018 5:05 AM, Lynne Noll wrote:
> -snip-
>
>
> However, the main purpose of the QMQRY utilities was getting around the lack of purchased SQL tools like embedded SQL in RPG.
>
> -snip-
>
>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>
>
> ________________________________
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> on behalf of Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
> Sent: Wednesday, February 21, 2018 8:37 AM
> To: RPG programming on the IBM i (AS/400 and iSeries)
> Subject: 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.
>
> Regards
> Vern
>
>
> --