Specifying WHERE clause in DB2 Connector not possible?

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
DSUser2000
Participant
Posts: 42
Joined: Tue Oct 20, 2009 8:36 am

Specifying WHERE clause in DB2 Connector not possible?

Post by DSUser2000 »

We are coming from DS7.5 with DB2 API stage and migrating to 8.7 but are facing the problem, that generating SQL in 8.7 Connector stage is extremely limited. Did we miss the WHERE condition or is this really not there anymore? Is there really just tablename and the columns? The SQL builder seems not really that good to us...
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

The default in Connector stages is SELECT and FROM clauses only.
To get a WHERE clause you need either the Builder or user-defined SQL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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