Procedure Overview

Stored procedures are compiled programs that can be stored on your system. Creating your programs as stored procedures allows you to call them from an SQL application. Stored procedures may be called repeatedly, may call other programs, and may be save to tape and restored on other systems.

You can create three types of stored procedures:

External stored procedure:
An external procedure can be any supported high level language program (except System/36* programs and procedures) or a REXX procedure.

SQL stored procedure:
An SQL procedure is defined entirely in SQL, and can contain SQL statements that include SQL control statements.

Java stored procedure:
A Java stored procedure is defined entirely in Java. You create a Java stored procedure from the New External Procedure dialog.

You can do the following tasks with procedures:

For more information about procedures, see Stored procedures in the SQL Programming topic in the Information Center Link to Information center.