× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2014

Re: Limits of SQL SET variable

There are 2 kinds of SET, at a very high level - various SET statements (SET OPTION, SET RESULT SETS, SET variable, etc.), and the SET clause of the UPDATE statement. SET variable is only for a host variable.

There is no SET clause in any form of SELECT that I know of. Think of it - SELECT is a READ operation - you don't change anything in RPG when you do a READ operation.

HTH
Vern

On 9/9/2014 3:05 PM, Gary Thompson wrote:
My limited experience using SET and reading DB2 for i SQL Reference 7.1
leads me to conclude SET can only update the value of a 'host' variable ?

And that SET cannot be used within an SQL Select ?

But, maybe, can be used within an embedded SQL Select where SET is
in a subselect or common table expression ?


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.