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 |
What is the difference between base table and view?
What are leaf pages?
What is host variable?
On the create tablespace, what does the CLOSE parameter do?
Give the name of some fields form sqlca.
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....
what is rebinding ?
Explain the function of data manager.
Can there be more than one cursor open for any program?
Why use RUNSTAT Utility?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What are the bind parameters ibm db2?