Re: compile option*NOUNREF

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

David

There is no such thing as an "SQLRPGLE" module as such - there is an 
SQLRPGLE source member type, however. Now AFAIK you don't HAVE to have 
an SQLRPGLE member type in order to compile something with embedded SQL. 
It's just handier in SEU and WDSC/RDi/etc. for syntax checking and all.

And there are DB2/400 attributes in the DSPMOD command, where you get 
the number of SQL statements, etc. The presence of this would indicate 
and SQL-ish module (It's called DB2/400 at V5R1 - maybe IBM use a 
different name in more recent releases)

I tested this on an ILE program - didn't do so with an OPM program using 
embedded SQL. I assume there is something similar. There are APIs to 
retrieve program information - different ones for ILE and OPM - that 
give you a module list with attributes, for ILE, and program information 
itself, for OPM.

Maybe you could run DSPPGM DETAIL(*MODULE) OUTPUT(*PRINT) and work 
through that spooled output, maybe CPYSPLF first to a PF, then read it, 
looking for the DB2/400 marker - or whatever it is at whatever release. 
This always has the risk of something being changed by IBM, of course.

HTH
Vern

David FOXWELL wrote:
> Never mind, for someone who has all his programs bound by copy, compiling with *NOUNREF to save space would be like a drop in the ocean.
>
> As for the list of modules, I set up a WDSC connection and filtered all the modules into a table. I can then show all the modules on the system and sort them on size, etc. But SQLRPGLE modules still show up as RPGLE.
>
>
>   
> > -----Message d'origine-----
> > De : midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de David FOXWELL
> > Envoyé : mercredi 28 avril 2010 10:00
> > À : Midrange Systems Technical Discussion
> > Objet : compile option*NOUNREF
> >
> > I wanted to try the new(ish) compile option *NOUNREF on an 
> > RPG module. Is this option not available if the module is SQLRPGLE?
> >
> > How can I get a list of all modules but distinguish between 
> > SQL and non SQL module?
> >
> > Thanks.
> >
> > --
> > This is the Midrange Systems Technical Discussion 
> > (MIDRANGE-L) mailing list To post a message email: 
> > MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> > list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, 
> > please take a moment to review the archives at 
> > http://archive.midrange.com/midrange-l.
> >
> >
> >