Generate the text of the routine

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.

SELECT data FROM informix.sysprocbody
   WHERE datakey = 'T'                   -- find text lines
   AND procid = 
      ( SELECT procid
      FROM informix.sysprocedures
      WHERE informix.sysprocedures.procname =
         'read_address' )