An SQL (internal) stored procedure is created or replaced using the COMPILE command, which takes a single SQL Stored Procedure Language (SPL) file as input. The encoding of this file must match that of the current session character set.
The remainder of this section describes the details of using regular SQL stored procedures.