Direct assignment using SQL statement?

rpkulkarni · #1 (**permalink**) 11-28-09, 06:15

Can I accomplish following thing in DB2 stored procedure or functions?

Code:

DECLARE count INTEGER;
..
..
..

SET count = SELECT COUNT(*) from USER_TABLE;

Basically I want to assign the value of number of rows present in USER_TABLE to variable "count". Above statement of course is not working.

Please advise.

Thanks
rpkulkarni

tonkuma · #2 (**permalink**) 11-28-09, 06:36

SET count = (SELECT COUNT(*) from USER_TABLE);

(SELECT .....) is a scalar full-select. And, scalar full-select is an expression.

rpkulkarni · #3 (**permalink**) 11-28-09, 06:55

Thanks for your advise. It worked correctly.

Regards,
rpkulkarni

stolze · #4 (**permalink**) 11-30-09, 08:40

Another alternative is a SELECT ... INTO ... statement. It is described in the manual, too.

Internet Services

Web Development

Digital Marketing

Consumer Tech