Connect and query table in DB2 using iSeries ODBC
Posted on 2005-05-02
I have a code in C++ that uses
1. Connects to the target database using ODBC connection created on the system.
2. executes sql queries on the table defined in the code. e.g. Select first_name, last_name from tblNames
Everything works fine with other ODBC's i.e. SQL server / oracle / msaccess ,etc. But for DB2 i am not able to reach the correct database / table.
I need help configuring correct odbc. Following are the details:
Driver(s) available: 1. Client Access ODBC Driver (32bit) - IBM Corporation
2. IBM DB2 ODBC Driver - International Buisness Machines Corporation
3. iSeries Access ODBC Driver - IBM Corporation
The information available from client is:
I configured a connection using drivers 1 & 3 above and was able to connect with the information available. However when i use SQLcon32 utility to get list of tables, i see the tables from QGPL and nothing from the Database/library that i am interested in. Also i tried to run sql query "Select * from libraryname.tblname" but the driver complains "[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - [Table name] in [DB] type *FILE not found.