db2 sql stored procedure

nic39 · #1 (**permalink**) 10-13-04, 14:19

Is there a way to add conditional logic in sql stored procedures
I want to say
if(my query return no rows) then
do this;
else
do other;

Thanks for any info

n_i · #2 (**permalink**) 10-13-04, 15:16

I think one of the ways to accomplish this would be

Code:

IF EXISTS (SELECT ... FROM ... WHERE ...) THEN...

vidyaraok · #3 (**permalink**) 10-19-04, 02:20

can use

get diagnostic cnt = row_count;
if cnt = 0 then
...

..

sathyaram_s · #4 (**permalink**) 10-19-04, 03:58

This may not be the best way to do existence checking ...

Cheers
sathyaram

Quote:

Originally Posted by vidyaraok

can use

get diagnostic cnt = row_count;
if cnt = 0 then
...

..

Internet Services

Web Development

Digital Marketing

Consumer Tech