CREATE PROCEDURE
The CREATE PROCEDURE statement registers a stored procedure with a database server. You can register the following types of procedures with this statement, each of which is described separately.
- External
- The procedure is written in a programming language such as C, COBOL, or Java. The external executable is referenced by a procedure defined at the server along with various attributes of the procedure.
- SQL
- The procedure is written exclusively in SQL statements. The body
of an SQL procedure is written in the SQL procedural language. The
procedure body is defined at the current server along with various
attributes of the procedure.
See CREATE PROCEDURE (SQL - external) and CREATE PROCEDURE (SQL - native).