Skip to main content
Question

AS/400 DB2 ODBC Error


bk
Contributor
Forum|alt.badge.img+10
  • Contributor

I have a support case in on this - C131989 - but figured I’d ask here as well. I have an existing workspace that’s been running fine every night for months. All it does is access several tables in an AS/400 DB2 database (via an ODBC connection) and export these to a SQL Server database. This is about as simple as an FME workspace can be i.e. one reader to one writer for several tables, no transformers. I now need to add a new table. When I try to import the feature type from the reader, I get the list of tables, select the one I want, and then get the following error:

Opening ODBC 3.x Reader

ODBC 3.x Reader: Dataset = GTCOUNTY.HTEDTA. Username = citywork. Password = ************

Connecting to database...

ODBC 3.x Reader: The DBMS name fetched by ODBC driver is 'DB2/400 SQL'

ODBC 3.x Reader: The DBMS version fetched by ODBC driver is '07.01.0015'

ODBC 3.x Reader: Database version is '7.1.15'

ODBC 3.x Reader: Current schema is 'citywork'

ODBC 3.x Reader: Now reading schema for LMASREP

Database Generated Error Information:

Database Error Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor SQL_CUR04D2E820 not open.

Database SQL Statement Text: SELECT * FROM "LMASREP" WHERE 1=0

SQL State: 07005

Variable Information:

ODBC 3.x Reader: Failed to get schema for feature type 'LMASREP'. Continuing with next feature type in the list

Closing ODBC 3.x Reader

I’ve also tried re-adding the existing tables and adding other tables and get the same error. So this isn’t table specific. It appears to be with all listed tables.

Finally, I have setup a linked server in the target SQL Server instance and can access these tables using the same user and ODBC connection.

Any ideas?

- Brooks

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings