IBM Support

Find any CL commands that have had their parameter defaults changed.

Question & Answer


Question

How do you create a report to find any CL commands that had their parameter defaults changed.

Answer

The IBM SQL Service OBJECT_STATISTICS can be used to create a report that shows any CL command that had their parameter defaults changed.
 

Authorization:

  • If the user has *EXECUTE authority to the library, and both *OBJOPR and *READ authority to an object, full details are returned.
  • Otherwise, partial information is returned along with an SQL warning of '01548'.
 
Using the Run SQL Scripts tool, run the following SQL:
 
select OBJNAME as Command,
       OBJTYPE as Object_type,
       OBJLIB as Command_library,
       OBJTEXT as Command_description,
       APAR_ID
    from table (
            QSYS2.OBJECT_STATISTICS('*ALL', '*CMD')
        )
    where APAR_ID = 'CHGDFT'
 
image-20220224071354-1
 
 
NOTE:  The report lists all commands in all libraries that have commands that had their parameter defaults changed.
NOTE 2: Change Command Default (CHGCMDDFT) command against the proxy command it changes the target command.
 
More information on the SQL Service on the following link:
 
 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHyAAM","label":"Security"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0;7.1.0;7.2.0;7.3.0;7.4.0;7.5.0;7.6.0"}]

Document Information

Modified date:
05 November 2025

UID

ibm16211844

Page Feedback