Re: sort with more than 2500 sort conditions
Posted: Tue Mar 04, 2008 1:46 pmshivkumar,
He is absolutely correct. Answer the following questions.
#1 How are you getting the values for those 2000+ if conditions?
#2 Are you dynamically building it or those values are constants?
#3 Why shouldn't you have those values in a file and use JOINKEYS to find all matching records?
I bet you will get a better solution if you answer the above questions.
Arun.
Dick said:
As has already been requested, post your requirements.
I suggest that if there is that much qualification going on there are better ways to meet your requirement than using 2500+ sort control statements.
Once we see what you are actually trying to accomplish, we may be able to offer some alternative.
He is absolutely correct. Answer the following questions.
#1 How are you getting the values for those 2000+ if conditions?
#2 Are you dynamically building it or those values are constants?
#3 Why shouldn't you have those values in a file and use JOINKEYS to find all matching records?
I bet you will get a better solution if you answer the above questions.
Arun.