Working with External SQL Stored Procedures

A stored procedure is a compiled program that can execute SQL statements and is stored at a local or remote Db2 server. An external SQL stored procedure is a stored procedure written exclusively in SQL statements, including SQL procedural language (SQL PL) statements. All SQL procedures that are created with a CREATE PROCEDURE statement that specifies either the FENCED or EXTERNAL options are external SQL stored procedures.