hi friends,

I wonder anyone will use Dynamic CALL statements... I don't think it has a real value... I accept it is really worth to have dynamic sql statements support... but dynamic call statements, i'm not sure....

Can anyone give a realtime scenario where dynamic call statements can be used. or in other words, are anyone using/used dynamic call statements in their sprocs.

plz correct me if i am wrong.

Jake

Hi

If you are talking about DB2 z/OS, you cannot dynamically execute the SQL-statement CALL. The only thing you can do is, CALL :HV,where HV contains the name of a stored procedure.

good to see your quick reply. i'm talking about DB2 UDB and moreover i like to know the need for the dynamic call statement and its real time usage in the industry. Hope I'm clear.

Jake

Hello!

Well you can think about the situation you do not know exactly what stored procedure you want to call. You might have a group of stored procedure exposing some sort of "interface" (same params, same return type, but of course different functionality). At runtime you will call dinamically the apropriate stored procedure depending on your flow.

Victor

hi friends,

When I went through the nesting of stored procedures, i found that you have to use the dynamic call statement for recursively calling the same procedure for successful compilation. If the static SQL is used instead, the procedure name will not be resolved at the compile time and this will generate a compile error.

Any other real time use???

Jake