RE: Is "Action" an Embedded SQL Reserved Word?

Jerry,

Have you tried running the query interactively? That will tell you if it is a reserved word or not. If it is, you can put double quotes around it (you'll also have to specify the column name in uppercase) and it will work.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Friday, September 18, 2009 4:33 PM
To: Midrange-RPG (rpg400-l@xxxxxxxxxxxx)
Subject: Is "Action" an Embedded SQL Reserved Word?

/free
EXEC SQL
SELECT action,
customer,

I am in the process of keying the lines above as embedded SQL into an SQLRPGLE source member using WDSc. WDSc color-coded the word "action" blue, which is supposed to indicate a keyword (SELECT is also blue).

I went to both the SQL Reference and SQL Programming manuals and could not find anything about "action" being *special* in either one. I have not finished keying the program yet so I don't what kind of errors the compiler (or pre-compiler) will throw at me.

Since "action" is a field name in a database file, I hope that there's nothing special about it and that the editor is just yanking my chain. Is "action" a reserved word in SQL? If so, how would I get around this, ahem, issue?

Thanks.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx