The SQL statements tab contains the code for the external SQL program that you are defining as a procedure. You can use the SQL statement examples and fill in the necessary information to make coding SQL easier.
If the SQL procedure is completely defined, click OK. Or select:
Note: After an SQL procedure has been created, the SQL statements cannot be changed. Also, no compile listing is generated when the function is created. If logic errors are later detected, the function must be deleted and redefined to change the SQL code. You should consider creating and testing your SQL statements elsewhere before creating them as an SQL Procedure.