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



Oh great !

How's about a SQL exit point to automatically change the statement before it is executed ?

________________________________

From: bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx on behalf of rob@xxxxxxxxx
Sent: Fri 27/02/2009 18:29
To: bpcs-l@xxxxxxxxxxxx; Midrange Systems Technical Discussion
Subject: [BPCS-L] V6R1 and new sql reserved work - RID



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
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com <http://www.dekko.com/>

--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: sean.mcgovern@xxxxxxxxxxxx



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.