I'm new to DB2 connectivity from DataStage using the DB2 Connector Stage and running into an issue with schema qualifiers. The existing SQL in our DataStage jobs don't require schema qualifiers on tables (Netezza). The SQL runs against the database table list as defined in the ODBC.ini file database name. However, with DB2 Connector I'm getting an error that it can't find tables under a schema matching my login ID.
What's the standard way to handle this? Am I stuck needing to qualify the tables in all of our SQL or is there a way to push a default schema variable or library list with the DB2 Connector Stage?
DB2 Connector Schema
Moderators: chulett, rschirm, roy