Re: compile option*NOUNREF

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.