How to execute stored procedures?



How to execute stored procedures?..

Answer / Mahak Singh

To execute a stored procedure in DB2, you can use either SPUFI (command-line interface) or QMF (graphical user interface). If using SQL scripts, the syntax would look like: `CALL <procedure_name> ([parameters]);`. For example:`CALL my_procedure(1, 'abc');`.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the difference between base table and view?

7 Answers  


What are leaf pages?

3 Answers  


What is host variable?

1 Answers  


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


Give the name of some fields form sqlca.

1 Answers  


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


what is rebinding ?

1 Answers   IBM,


Explain the function of data manager.

1 Answers  


Can there be more than one cursor open for any program?

1 Answers  


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  


What are the bind parameters ibm db2?

1 Answers  


Categories