Oracle Connector: Generated SQL + Where clause

MrBlack · Post by **MrBlack** » Thu Sep 04, 2014 2:07 pm

So this might be a stupid question, but I'm checking out the new Oracle Connector after a datstage stage version upgrade. In the old Oracle OCI stage you could chose generate SQL and also specify a WHERE clause. This new oracle stage doesn't seem to have the same functionality?!? There's a lot that is different so either they've hidden it or it's not there anymore.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 04, 2014 4:54 pm

It's not there, but you can append it to the Table Name field. The content of the Table Name field becomes the FROM clause of the generated SQL. Just make sure that the WHERE clause (and GROUP BY, HAVING and ORDER BY if you wish) occur in the correct order and after anything that needs to end up in the FROM clause.