Re: Embedded SQL

[Rob Berendt <rob@xxxxxxxxx>]

Shoot from the hip answer is yes, the SQL product is 
required, and that it what we do.  The SQL product 
precompiles it and then passes it through the appropriate 
RPG compiler.  Basically it takes your embedded SQL and 
replaces it with calls to various API's and some other 
items.  There are people that code their SQL this way 
instead of buying the SQL product.  Frankly, I would think 
the maintainability would not be as nice.  The SQL precompiler 
has some irritations, such as it doesn't like embedded 
/COPY statements.  Irritations yes, but an excuse to not 
use it, no.





oertlim@s054.aone.net.au on 06/06/2000 07:15:43 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:      
Fax to: 
Subject:        Embedded SQL

Hi,
To embed SQL into RPG, is the SQL lic pgm required?
Is there any place that has example code (RPGIII & IV)?
Thanks,
Matthias

-- 

---------------------------------------------------------------------
Matthias Oertli   <oertlim@s054.aone.net.au>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---