×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.