I am using DB2 API stage to read the data with with "custom sql query"..
Code: Select all
job..EMP_MTH: [IBM][CLI Driver][DB2/AIX64] SQL0206N "PRD_LN" is not valid in the context where it is used. SQLSTATE=42703SQL0206N "PRD_LN" is not valid in the context where it is used. SQLSTATE=42703
More particularly ,when I give table name as Parameter (Given parameter :EMP_MTH=EMP_M01 )..why this is happening any
![Idea :idea:](./images/smilies/icon_idea.gif)
Code: Select all
"SELECT EMP_NO,....CCS.EMP_M01 "..Working fine
"SELECT EMP_NO,....CCS.EMP_MTH "...Giving error