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
- 80 Column Punched Cards and the History of RPG on the AS400
- Contact Us
- API Example - Deleting Old Spooled Files
- AS400 APIs
- Make a Home made, open source mp3 Player
- What is QZHQSSRV job?
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
- UDATE and *DATE in AS400 RPG
- Using QCLRDTAQ to clear data queues in CL and RPG
- Other as400 tips sites
No comments:
Post a Comment