Calling Stored Procedures within Stored Procedures 1

[Goodz13]

Hello,

I am trying to call a stored procedure from another stored procedure. How can this be done?

example:

CREATE PROCEDURE MYDATABASE.PROC1
    ()

    LANGUAGE SQL   
    BEGIN ATOMIC

    DECLARE MYVAR VARCHAR(10);

    SET MYVAR = CALL MYDATABASE.PROC2();

    END @
   

CREATE PROCEDURE MYDATABASE.PROC2
    (OUT MYVAR VARCHAR(10))

    LANGUAGE SQL   
    BEGIN ATOMIC

    SET MYVAR = 'HELLO';
    
    END @

 

[sathyarams]

SET MYVAR = CALL MYDATABASE.PROC2();
must be
CALL MYDATABASE.PROC2(MYVAR);

HTH

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp