Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CASE clause

Status
Not open for further replies.
oana12

oana12

Programmer
Jan 6, 2005
21
CA
Hi,
How many WHEN condition can you have in a CASE clause in DB2?

Thankns

 
Sort by date Sort by votes
Beats me. Doesn't say in the documentation I have. How many When conditions do you want to use?
 
Upvote 0 Downvote
I have a cursor with 2 CASE clause . Every CASE clause has 80 WHEN codndition and every time a ran this procedure I am disconnected from the server. If I let only one CLAUSE it is ok but with both no.
Any help?

Thanks
 
Upvote 0 Downvote
I just ran 2 Case statements with over 100 WHEN clauses in each and the query ran fine. What platform are you using?
 
Upvote 0 Downvote
I resolved the problem, thank you. I had to modify a configuration parameter.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
166
mikrom
mikrom
cloudtwter
  • Locked
  • Question
CASE DATE
Replies
5
Views
98
cloudtwter
cloudtwter
skcvasanth
  • Locked
  • Question
WHERE IN CLAUSE WITH same literal
Replies
3
Views
65
SkipVought
S
ShalakaT
  • Locked
  • Question
'where exists clause'
Replies
1
Views
181
fredericofonseca
fredericofonseca
roopsingh
  • Locked
  • Question
Case statement in Group by clause in IBM DB2 LUW 10.1
Replies
6
Views
138
roopsingh
roopsingh

Part and Inventory Search

Sponsor

Back
Top