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
user activity issue
Moderators: chulett, rschirm, roy
Re: user activity issue
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.
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.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.