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
- Using QCLRDTAQ to clear data queues in CL and RPG
- opensourceCMS.com - Try before you install!
- Creating an as400 Query
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
- UDATE and *DATE in AS400 RPG
- as400 iSeries NetServer Disabled user profiles
- Cool Make Project Photos
- Announcing the Preview Release of Ubuntu 5.10 (Breezy Badger)
- AS400 API - QCMDEXC - Execute Command
- Display Command Line Window (QUSCMDLN) API
No comments:
Post a Comment