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
- List Job (QUSLJOB) API
- Using QCLRDTAQ to clear data queues in CL and RPG
- Make a Home made, open source mp3 Player
- AS400 Job Scheduler
- What is QZHQSSRV job?
- Creating an as400 Query
- UDATE and *DATE in AS400 RPG
- AS400 APIs
- API Example - Deleting Old Spooled Files
- AS400 Jobs: Do you have a job at the moment?
No comments:
Post a Comment