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
- UDATE and *DATE in AS400 RPG
- AS400 Job Scheduler
- Creating an as400 Query
- Adobe Flex 2.0 Beta
- ibm as400 manuals v5r4
- Using as400 QRCVDTAQ api to retrieve a message / entry from a dataqueue
- Privacy Policy
- IBM WebSphere Developer Technical Journal: Maintain continuous availability while updating WebSphere Application Server enterprise applications
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
No comments:
Post a Comment