Working with Native SQL Stored Procedures

A stored procedure is a compiled program that can execute SQL statements and is stored on a local or remote Db2 server. A native SQL stored procedure is a stored procedure written entirely in SQL, including SQL Procedural Language (SQL PL) statements. Any SQL procedures created using the CREATE PROCEDURE statement, without the FENCED or EXTERNAL options, are considered native SQL procedures.