Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    32

    Unanswered: call a procedure with in a procedure

    Hi DBA's

    How to call a stored procedure with in a stored procedure

    for example

    in a stored procedure we declare a variable and assign the value

    select substr('EXAMPLE',1,4) into vlist from sysibm.sysdummy1;

    how do assign the output of a stored procedure to other variable in a stored procedure

    call (a,b,?)

    how do we get the output to a variable in a stored procedure

    any examples of calling stored procedures in stored procedures


    Thanks

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    for example

    in a stored procedure we declare a variable and assign the value

    select substr('EXAMPLE',1,4) into vlist from sysibm.sysdummy1;
    For example

    call another_proc(a,b,vlist);

    where another_proc was created by
    CREATE PROCEDURE another_proc(IN x data-type1 , IN y data-type2 , OUT z data-type3) ...

  3. #3
    Join Date
    Mar 2010
    Posts
    32
    thanks

    it works

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •