A stored procedure has been created with the following statement:
CREATE PROCEDURE proc1 (IN var1 VARCHAR(10), OUT rc INTEGER)
SPECIFIC myproc LANGUAGE SQL …
What is the correct way to invoke this procedure from the command line processor (CLP)?
A.
CALL proc1 (‘SALES’, ?)
B.
CALLmyproc (‘SALES’, ?)
C.
CALL proc1 (SALES, ?)
D.
RUN proc1 (SALES, ?)
A.
CALL proc1 (‘SALES’, ?)
0
0
Calling procedures from the Command Line Processor (CLP)
You can call stored procedures by using the CALL statement from the DB2® command line processor interface. The stored procedure being called must be defined in the DB2 database system catalog tables.
0
0