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



IBM added a new reserved word in SQL - RID. So, if you're doing a
statement like
select RID,... FROM FRT...
You will need to change it to:
select "RID",... FROM FRT...

Where else might this be used?
SELECT SYSTEM_COLUMN_NAME, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
FROM qsys2/syscolumns
WHERE system_column_name='RID'
ORDER BY system_table_name

I am finding tables like: FRT, KRT, RIP

http://preview.tinyurl.com/abxh6g
http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/db2/rbafzscarid.htm?tocNode=%74%6f%63%3a%72%7a%61%68%67%2f%69%35%6f%73%2f%34%2f%37%2f%37%2f%35%2f%31%2f%31%31%35%2f

Since some of this SQL is buried into our vendor's code, anyone have any
alternative suggestions than changing all their imbedded SQL?
Apparently RID was really popular for "Record ID; RT/RZ"


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.