× 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.



Bingo, Chuck. You nailed it. Thank you.



On 10/8/2015 5:15 PM, CRPence wrote:
... The given example could have been clearer, having qualified the
column name(s), and including the optional AS keyword to make the X
appear less like a spurious data from a mis-type\finger-check.

Try the following revision to what you have quoted above; I used CID
instead of X, hoping to make clear, that the text is intentionally
included, and the identifier as qualifier on the column-name references
helps elucidate the purpose of the AS-identifier:

exec SQL
select CID.ODOBTX
into :wUserName
from Table( QSYS2/USERS() ) AS CID
where CID.ODOBNM = 'MARTIN'
;

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.