user activity issue

[India2000]

Hi all,
I have a scenrio whre in sequence UA has 2 where clauses and then connecte to the sequencer with "ALL''
1 uvwhereclause If type='A' Then "Where 1=2" Else ""
2.uvexternalwhere if type='A' then 'where 1=2' else '' CC''

What does this condition mean?Please can anyone help me out?

Thanks a lot

[roy]

Hi,
My guess would be you have a job parameter named type
according to it's value the 2 user variables get theier value set,
If type = 'A' both are set to 'where 1=2' (like saying @FALSE, it never happens) and if type <>'A' the first is set to an empty string and the second gets " CC"
But this is as much as anyone can say with the givven info.
IHTH (I Hope This Helps) ...

Topic moved since a sequence job apllies to server and parallel alike.

[ray.wurlod]

You seem to be using a sledgehammer to crack a nut here. I'm guessing you are setting up WHERE clauses for something downstream, maybe a Filter stage. Why not use type <> "A" as the first expression itself?