• Subject: Re: RPG SQL precompiiler
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Thu, 15 Jul 1999 9:01:44 -0500

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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].