Hi,
I am using Connect-IT ver 3.5.0.5725GA.
Want to Transfer data from DB2 to Oracle database.
ODBC setting for DB2 has been setup and it connects succesfully.
If I add a DBNAME parameter, then the connection scenario does not show my table listing. Take the parameter away & then I see the table listing on the Mapping screen.
I now mapped the fields from DB2 to Oracle and it gives an ODBC error (shown below).
I know that you have to append the Schema name before the tableName, but do not know how/where to append it to the tablename.
Has anyone encountered this problem.
Thanx in advance.
2(0) ODBC error: [IBM][CLI Driver][DB2] SQL0204N \"UserName.TableName\" is an undefined name. SQLSTATE=42704\r\n SQLSTate: S0002
2(0) SQL statement 'SELECT O1.T2H_ACTION FROM TableName O1 FOR FETCH ONLY' could not be executed
I am using Connect-IT ver 3.5.0.5725GA.
Want to Transfer data from DB2 to Oracle database.
ODBC setting for DB2 has been setup and it connects succesfully.
If I add a DBNAME parameter, then the connection scenario does not show my table listing. Take the parameter away & then I see the table listing on the Mapping screen.
I now mapped the fields from DB2 to Oracle and it gives an ODBC error (shown below).
I know that you have to append the Schema name before the tableName, but do not know how/where to append it to the tablename.
Has anyone encountered this problem.
Thanx in advance.
2(0) ODBC error: [IBM][CLI Driver][DB2] SQL0204N \"UserName.TableName\" is an undefined name. SQLSTATE=42704\r\n SQLSTate: S0002
2(0) SQL statement 'SELECT O1.T2H_ACTION FROM TableName O1 FOR FETCH ONLY' could not be executed