If your trying to run an SQL statement on the as400, but are getting errors because one of your column names is an DB2/400 SQL reserved word, try the following.
Wrap double quotes around the offending column name, and also make it uppercase. This should resolve the reserved words problem!
Sunday, September 20, 2009
Subscribe to:
Post Comments (Atom)
Popular Posts
- as400 Iseries Tips
- Creating an as400 Query
- Contact Us
- What is QZHQSSRV job?
- Ten CSS tricks you may not know : evolt.org, Code
- Daniel Dan Carter Beard's Outdoor Handy Book or American Boy's Book of Sport - October 15, 1896
- QUSRJOBI API (Retrieve Job Information) as400
- iReport - OpenSource Java Reporting Tool
- AS400 APIs
- Using QCLRDTAQ to clear data queues in CL and RPG
No comments:
Post a Comment