My Oracle Support Banner

DG4ODBC - Selecting DB2 iSeries Column Alias is failing with ORA-00904 (Doc ID 2751107.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Database Gateway for ODBC connecting to DB2 on iSeries. DB2 iSeries creates alias names for the column names.

Getting ORA-00904 when using column name alias via database link

Cause

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
Symptoms
Cause
Solution


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