Will Decode function works in IBM DB2 Database? Will Decode function works in IBM DB2 Database? jayanthsid (Programmer) (OP) 11 Jun 19 16:50 When executing the below query, i am getting error "SQL Error : [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; RE: Will Decode function works in IBM DB2 Database? fredericofonseca (IS/IT--Management) 11 Jun 19 17:54 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 www.syssoft-int.com FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an answer?