Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2001
    Posts
    32

    Post Unanswered: DB2 UDB 7.1 SQL stored procedures

    Can anyone know how to invoke procedure dynamically in SQL stored procedure language ?.i.e the procedure name will be known only at run time.It will be assigned to a declared variable at run time.Using CALL statement we can call procedure.But procedure name should be hardcoded this I want to avoid.Please give your suggestion.

  2. #2
    Join Date
    Jul 2002
    Posts
    19
    Hi
    Are these procedures parameterized?. What i mean to ask is if these procedures have different number of parameters to be passed then the code will be a bit clumsy.
    Otherwise it can be done

  3. #3
    Join Date
    Jul 2001
    Posts
    32
    Thanks for reply Mr.CGagendran.

    If it is possible,Can you explain how to do it in detail for sql stored procedure with out parameters?.


    If it is parameterised,There may be some way to do.Can you explain this also.Please this is urgent request .

Posting Permissions

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