There's a big difference between "transformed into ILE C and Compiled" and
"C compiler is no longer required". There could always be a subset of C
on the machine for just such necessities.
If I copy the sample stored procedure here:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzcrtpsf.htm?lang=en
and put it into a source member and then use
RUNSQLSTM SRCFILE(ROB/QPGMSRC) SRCMBR(SQLSAMPL2)
MSG ID SEV RECORD TEXT
SQL7989 0 1 Position 1 Procedure MEDIAN_RESULT_SET was created in
ROB.
wrkobj rob/med*
Object Type Library Attribute Text
MEDIA00001 *PGM ROB CLE SQL PROCEDURE MEDIAN_RESULT
What is the attribute of the program above?
DSPPGM PGM(ROB/MEDIA00001) DETAIL(*MODULE)
Module attributes:
Module . . . . . . . . . . . . . . . . . . . . : MEDIA00001
Library . . . . . . . . . . . . . . . . . . : QTEMP
Source file . . . . . . . . . . . . . . . . . : QSQLSRC
Library . . . . . . . . . . . . . . . . . . : QTEMP
Source member . . . . . . . . . . . . . . . . : MEDIA00001
Module attribute . . . . . . . . . . . . . . . : CLE
Module creation date/time . . . . . . . . . . : 04/29/15 13:24:40
Source file change date/time . . . . . . . . . : 04/29/15 13:24:40
Let's try something really freaky.
SAVOBJ OBJ(MEDIA00001) LIB(ROB) DEV(*SAVF) OBJTYPE(*PGM) SAVF(ROB/ROB)
ftp the save file to my GDI lpar.
telnet to my GDI lpar
RSTOBJ OBJ(MEDIA00001) SAVLIB(ROB) DEV(*SAVF) OBJTYPE(*PGM) SAVF(ROB/ROB)
RUNQRY QRYFILE((QSYS2/SYSPROCS))
and there it is.
....+....1....+ 3....+...14....+.. 6....+...27....+ 9....+...40....+..
SPECIFIC_SCHEMA SPECIFIC_NAME ROUTINE_SCHEMA ROUTINE_NAME
ROB MEDIAN_RESULT_SET ROB MEDIAN_RESULT_SET
..+...70....+.
EXTERNAL_NAME
ROB/MEDIA00001
Rob Berendt
midrange.com
