DB2 connectivty problem
Posted: Fri Dec 04, 2009 7:31 pm
I am trying to connect to DB2 database table using DB2 Enterprise stage,we have set the env variables in dsenv and able to read from some of the DB2 database tables but for others though we are able to import view the table data at import by plug-in metadata,we are not able to view the data when we try to write a query selecting single column.It throws the following error "DB2_Configure..DB2_UDB_API_6: [IBM][CLI Driver][DB2] SQL0206N "DSN8710.DEPT.DEPTNO" is not valid in the context where it is used. SQLSTATE=42703
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT DSN8710.DEPT.DEPTNO FROM PDB2.DSN8710.DEPT '. See following DB2 message for details.
DB2_Configure..DB2_UDB_API_6.DSLink1: DSP.Open GCI $DSP.Open error -100."
DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT DSN8710.DEPT.DEPTNO FROM PDB2.DSN8710.DEPT '. See following DB2 message for details.
DB2_Configure..DB2_UDB_API_6.DSLink1: DSP.Open GCI $DSP.Open error -100."