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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.