- What is stored procedure?
- How many types of stored procedures?
- What are those?
A stored procedure is a user-written program that can be called by an application with an SQL CALL statement. It is a compiled program that is stored at a DB2 server, and can execute SQL statements. Stored procedures can be called locally (on the same system where the application runs) and remotely (from a different system). However, stored procedures are particularly useful in a distributed environment.
Two types of Stored procedures
- internal stored procedures – written in SQL
- external stored procedures – written in COBOL, PL/I, C,C++,JAVA, Assembler and REXX