@declare in stored procedure

wishlister · #1 (**permalink**) 03-12-07, 19:41

db2 ESE
i just want to get a hint.. because whenever i create stored procedure, i don't know when will to declare variables or not. it also confused me when i see examples with or without variable declaration, but both works! tnx..

ARWinner · #2 (**permalink**) 03-13-07, 09:00

I am not sure if I understand your question properly, but we only declare variables if they are needed int the stored procedure.

Andy

stolze · #3 (**permalink**) 03-13-07, 13:23

Declaring variables in SP is straight forward:

Code:

CREATE PROCEDURE ...
   BEGIN
      DECLARE var1 INT;
      SET var1 = ( SELECT ... );
   END@

Internet Services

Web Development

Digital Marketing

Consumer Tech