DB2 Connector Schema

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gsbrown
Premium Member
Premium Member
Posts: 148
Joined: Mon Sep 23, 2002 1:00 pm
Location: USA

DB2 Connector Schema

Post by gsbrown »

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?
Top
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

It will be ideal to fully qualify the table name. However, if that is not desirable/possible, then followthis link to see various options for handling unqualified table names.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”