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