About the Filter Stage

hello105 · Post by **hello105** » Sat Sep 22, 2007 11:48 pm

Hi all,

When i use the filter stage,can i use the bracket in the where clause?

for example,the where clause maybe like this: a = 3 or (b = 2 and c = 4) or (d=5 and e =6)

can this be ok?? thanks!

ray.wurlod · Post by **ray.wurlod** » Sun Sep 23, 2007 4:26 am

Welcome aboard.

Why not try it, or look in the on-line help or in the Parallel Job Developers Guide (the chapter on the Filter stage)?

hello105 · Post by **hello105** » Mon Sep 24, 2007 8:04 am

i install the datastage in the windows platform,so it can not run the parallel job

maybe someone can help me,thanks

ray.wurlod · Post by **ray.wurlod** » Mon Sep 24, 2007 2:14 pm

hello105 wrote:i install the datastage in the windows platform,so it can not run the parallel job

Then you don't need the Filter stage. Even if you only have server jobs, you can read the Parallel Job Developer's Guide - it is one of the standard manuals set.
There is a version of DataStage (7.5x2) that supports parallel job design and execution on Windows platforms. Version 8.x also supports parallel job design on Windows.

mcs_dineshm · Post by **mcs_dineshm** » Tue Sep 25, 2007 8:30 am

yeah,it's possible to use brackets in the filter stage, i tried it's working.