Re: Client/Server on the AS/400

[Pete Hall <peteh@xxxxxxxxxx>]

At 12:59 PM 5/25/98 -0500, Vernon Hamberg wrote:
>What Marc Zylka was referring to, I believe, is the new feature in v4r2,
>that you can use native SQL as a programming language—no embedding in RPG
>or COBOL or REXX. The resulting source is converted into C source and then
>compiled. There are, apparently, extensions to SQL, like 'if' and 'do'—I've
>not seen it yet but heard it discussed at Connections Conference recently.

That could very well be the case. I saw that in News/400 (I think), but haven't 
played with it. I didn't realize you needed a C compiler. The kids colored all 
over my mental notepad. I thought this was the "wrapperless" SQL procedure. 
Apparently there's additional overhead involved because it uses dynamic bind 
and must be prepared each time it is executed, but it is largely portable so 
would be handy for systems that must also run against databases other than 
DB2/400...



Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| 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
+---