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

Birgitta,

Thanks. I knew about enclosing a field or file in double quotes, but must have been playing Led Zeppelin too loud on Friday.

I took another poster's advice and ran the statement through STRSQL (V5R4). It accepted both action and "ACTION". Anyway, WDSc seems to be happier with "ACTION".

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

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Saturday, September 19, 2009 9:09 AM
To: 'RPG programming on the IBM i / System i'
Subject: AW: Is "Action" an Embedded SQL Reserved Word?

Hi,

action is indeed a reserved word (it is for example used in "NO ACTION" when
implementing referential integrities or "EXTERNAL ACTION" when creating an
UDF).
You'll find all reserved words in the Appendix H in the SQL Reference
(Release 6.1).
If you column/field name is action, just surround the field name with double
quotes, but use capital letters. When using double quotes your field names
get case sensitive.

Select "ACTION", Customer, ....
From ...

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Jerry Adams
Gesendet: Friday, 18. September 2009 22:33
An: Midrange-RPG (rpg400-l@xxxxxxxxxxxx)
Betreff: 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