CASE Statement

[Former Member]

How many WHEN are possible in one CASE from performance point of view?

[Former Member]

HI,

NO limit.. you can use any number.

regards,

nazeer

[Former Member]

Hi,

You can use as many as WHEN in a single CASE Statment

regards

Sudheer

[Former Member]

Thanks for quick response; Eventhough I havenot face any problem for this, I just want to know the limitation. Still, I am not satisfied about the answer - NO LIMIT. As I think, there should be some limit.

[seshatalpasai_madala]

Hi,

There is no limit beacuse at once only ONE WHEN will be executed assuming that all your WHEN's are distinct. So you can have as many WHEN's as you want.

Regards,

Sesh

[Former Member]

There is of course a limit !! Nothing in the world is without limit !!

However, you should not run into that limit, so even hundrets of cases should work.

[Former Member]

Hi

to avoid the nested loop case and endcase is there

so there is no limit to whens

you can any number of when

when ever the that values comes then directly control goes to that place so no need to think about performance in this case

reward if usefull

[Former Member]

Hi Friendz,

Thanks for responding my question. I got the answer and so I am closing this.

[ThomasZloch]

so what on earth is the answer? 42?

[roberto_rodriguez2]

This message was moderated.

[rainer_hbenthal]

The limit is the main memory when editing the report.

[ThomasZloch]

Please refrain from bumping up my old "jokes"  

[RaymondGiuseppi]

HG2G rules