My Oracle Support Banner

Error QSYS.ORACLEGTW IS AN UNDEFINED NAME Using DG4DRDA to Connect to AS400 or iSeries (Doc ID 1555324.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database Gateway for DRDA - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


Using version of the Database Gateway for DRDA (DG4DRDA) connecting to an AS/400 or iSeries , the following error occurs when issuing a select statement against an AS/400 DB2 file.

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver][DB2]QSYS.ORACLEGTW IS AN UNDEFINED
NAME. COLLECTION {HY000,NativeErr = -204}[Oracle][ODBC DB2 Wire Protocol
driver]File not found '.odbc.ini'. {HY000,NativeErr = 1509}


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.