Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Dynamic Stored Procedure Calling


    How can I call the SP dynamically?

    My Scenario

    I know SP name and Parameter Name. But Parameter Sequence I will not know while calling the SP.
    So i want to call the SP with Named parameter

    For Ex:

    In SQL
    exec <SPNAME> <ParameterName> = Value, <ParameterName> = Value
    In Oracle
    <SPNAME> (<ParameterName => value, <Parametername> => value)

    So System will assign the Value to the particular Parameter. I can call the SP in any sequence.

    How can i do this type of requirement in DB2?
    Kindly help us to solve this problem

    DB2 Server details : Iseries Server - V5R3

  2. #2
    Join Date
    Aug 2001
    I have not seen a parameter-value construct in db2 ...

    One way is to read the data from the system catalog tables and build the CALL statement .. If you have overloaded the SPs, then this technique may get even more complicated ...

    There could be better solutions

    Have you checked the Oracle - DB2 Migration guides?

    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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