SQL in filter stage

zulfi123786 · Post by **zulfi123786** » Fri Jan 22, 2010 12:43 am

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?

sureshreddy2009 · Post by **sureshreddy2009** » Fri Jan 22, 2010 1:28 am

I think in datastage filter stage, you can use sql where clause conditions, these conditions are same in any flavour

ray.wurlod · Post by **ray.wurlod** » Fri Jan 22, 2010 2:16 am

Except that you can use regular expressions, which I've only really seen in Informix.

chulett · Post by **chulett** » Fri Jan 22, 2010 8:52 am

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.