Problem with column USER

[Morke275]

Hi!
I created a database using a key column called USER which is giving me a lot of problems. I cant select anything using that column (neither "... where USER='bla'" or "... where USER like 'bla'"). All other columns works fine. Any ideas what the problem can be?

 

[gregsimpson]

Morke275,

I think USER is a reserved word. I tried running the following query, which effectively returned the User-ID I'm logged on as, DB2USER1.

db2 select user from sysibm.sysdummy1

1
--------------------------------------------------------------------------------------------------------------------------------
DB2USER1

1 record(s) selected.

Cheers
Greg

 

[Morke275]

OK, I started to suspect just that. Thanks a lot!