Re: RPG SQL precompiiler

[Rob Berendt <rob@xxxxxxxxx>]

I don't understand your question.  Are you saying that we 
can't do the following:

update filea
        set qty=:qtyonhand
        where itemnum=:partno

And on the other part - about adding non standard SQL features.  
I'd just as soon IBM try to get the standards bodies to accept 
it first, within reason.





ncsmith@gate.net on 07/15/99 12:50:18 AM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: RPG SQL precompiiler


Also, a general question I have for the developers is:

If I can Insert from a host variable and select into a host variable, why I
can't I update from a host variable?

I know the answer is probably going to
be because normal SQL doesn't support it, but what is normal about our
precompiler?  As long as it is embedded into RPG anyway, it certainly isn't
going to be used anywhere else, so why can't we have some additional
functionality added to it.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *