How to execute stored procedures

The following is the process to execute the stored procedures:

In the command line type
db2 connect to Sample;
db2 -td@ -vf createSQLproc.db2

Type the entire script. After completion of entering the script save the script

Execute the script by invoking the CALL command from Command editor
-CALL Sample;

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.