Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
Back to discussions
Expand all | Collapse all

ODBC prepends username to db object

  • 1.  ODBC prepends username to db object

    Posted 05/12/20 11:34 AM
    I'm running into an issue where the DB2 ODBC driver ( 10.05.00.420 ) is evidently pretending database objects with username <username>.<db-object> so queries are failing.  Attempting to hard code schema.db-object resulted in the same error: (WA05108 is the username)

    ** E ** ERROR [42S02] [IBM][CLI Driver][DB2/AIX64] SQL0204N  "WA05108.MDMVW_HR_GETCMPS" is an undefined name.  SQLSTATE=42704

    Apologies if this is off topic for this discussion, but I wasn't able to find one that seemed more appropriate.  Figured I'd try and maybe get lucky :-).

    Thanks in advance,
    Al

    ------------------------------
    Albert Spohn
    ------------------------------

    #Db2


Related Content