Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connect-It DB2 ODBC Error

Status
Not open for further replies.

golw

Programmer
Feb 21, 2008
1
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top