Will Decode function works in IBM DB2 Database?

[jayanthsid]

When executing the below query, i am getting error "SQL Error [42703]: [SQL0206] Column or global variable C1 not found." Can any one explain why i am getting this error.

SELECT DECODE(c1, 7, 'a', 6, 'b', 'c') FROM SYSIBM.SYSDUMMY1;

 

[fredericofonseca]

error is very clear - Column or global variable C1 not found

so either declare the variable correctly or use a table that contains the column you wish to decode

Code on the manuals are example only - not full and as you would have noticed on the manual where that decode is copied from it does not specify the from clause.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886