sql error:SQL0206N in db2 v9.1
Posted on 2011-03-03
I am getting the below error which selecting a column from the table
$ db2 "select COMPANY_CODE_CURRENCY from COGNOS.DIM_COMPANY_CODE_SPEND"
SQL0206N "COMPANY_CODE_CURRENCY" is not valid in the context where it is
But, the same column is accesable when I select by using a * or count(*)..Its giving result
Please suggets me a solution for this