RE: RPG and SQL Compilers

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Jon Paris wrote:

>> Right you are!  Compile any SQL RPG program and ask for the listing.
>> You'll see the final results of the pre-compiler's work there

>Not really - you won't see the "compiled" SQL code that does the real work.

You're right (of course!)  I jumped the gun looking at the calls to
QSQROUTE.  

>Can't remember exactly where it is stored, in the program's associated
>space probably.  There is no way you can write your own pre-compiler - you
>could write something to generate the same RPG code as the pre-compiler
>does but that wouldn't do anything 'cos all the bits under the covers would
>be missing.  You could generate calls to the SQL CLI APIs (see the
>ubiquitous redbook for examples) but I doubt that it would be as efficient.

Drat :-(    The CLI APIs do work very nicely though...

>Your efforts would be better spent filling in reader comment cards for the
>SQL manuals and telling them the current situation needs fixing!

The last time I sent in a suggestion to the manual folks, I got a very
polite letter back explaining that they determine the documentation and not
the specifications.  Perhaps there is another ear we can more profitably
bend?

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---