Page 1 of 1

Specifying WHERE clause in DB2 Connector not possible?

Posted: Thu Mar 28, 2013 10:17 am
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...

Posted: Thu Mar 28, 2013 3:24 pm
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.