var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dynamic Stored Procedure Calling
How can I call the SP dynamically?
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
exec <SPNAME> <ParameterName> = Value, <ParameterName> = Value
<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
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.