Page 1 of 1
SQL in filter stage
Posted: Fri Jan 22, 2010 12:43 am
by zulfi123786
In the filter stage we can use SQL statements based on which the data is filtered, which flavour of SQL is supported by the filter stage is it IBM DB2 or Oracle or TeraData or is it a not a native of any kind but a mixture of all?
Posted: Fri Jan 22, 2010 1:28 am
by sureshreddy2009
I think in datastage filter stage, you can use sql where clause conditions, these conditions are same in any flavour
Posted: Fri Jan 22, 2010 2:16 am
by ray.wurlod
Except that you can use regular expressions, which I've only really seen in Informix.
Posted: Fri Jan 22, 2010 8:52 am
by chulett
It's documented as "standard SQL" and the specific Boolean operators and string handling it supports are documented in the Parallel Job Developer's Guide pdf.