After you create an SPL routine, it is stored in the sysprocbody system
catalog table. The sysprocbody system catalog table contains
the executable routine, as well as its text.
To retrieve the
text of the routine, select the data column from the sysprocbody system
catalog table. The datakey column for a text entry has the
code T.
The SELECT statement in the following figure
reads the text of the SPL routine read_address.Figure 1: SELECT
statement to read the text of the SPL routine.
SELECT data FROM informix.sysprocbody
WHERE datakey = 'T' -- find text lines
AND procid =
( SELECT procid
FROM informix.sysprocedures
WHERE informix.sysprocedures.procname =
'read_address' )