RE: compile option*NOUNREF

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> I wanted to try the new(ish) compile option *NOUNREF on an RPG module.
> Is this option not available if the module is SQLRPGLE?

The command reference or RPG reference for the version of the OS that you're
using should be able to answer that.

> How can I get a list of all modules but distinguish between SQL and non
> SQL module?

The only way I have found is to use DSPPGM DETAIL(*MODULE).  I'm sure
there's an API but it hasn't been that important to me - yet.  Anyway, for
SQL modules, there is a DB2400 section (missing for non-SQL) that (when
displayed, in English) looks like this:

                                                                        
 DB2/400 module attributes:                                             
   Number of SQL statements . . . . . . . . . . . :   37                
   Commitment control . . . . . . . . . . . . . . :   *NONE             
   Relational database  . . . . . . . . . . . . . :   *LOCAL            
   Naming convention  . . . . . . . . . . . . . . :   *SYS              
   Allow copy of data . . . . . . . . . . . . . . :   *OPTIMIZE         
   Allow blocking . . . . . . . . . . . . . . . . :   *ALLREAD          
   Delay PREPARE  . . . . . . . . . . . . . . . . :   *NO               
   Close SQL cursor . . . . . . . . . . . . . . . :   *ENDACTGRP        
   Date format  . . . . . . . . . . . . . . . . . :   *MDY              
   Date separator . . . . . . . . . . . . . . . . :   /                 
   Time format  . . . . . . . . . . . . . . . . . :   *HMS              
   Time separator . . . . . . . . . . . . . . . . :   :                 
   Default Collection name  . . . . . . . . . . . :   *NONE