IBM Support

QSYS2.OBJECT_STATISTICS()

News


Abstract

The OBJECT_STATISTICS table function returns information about objects in a library.

Content

For complete detail, visit this IBM Knowledge Center page: OBJECT_STATISTICS table function

Enhanced with IBM i 7.4 SF99704 Level 13 and IBM i 7.3 SF99703 Level 24:

  • Enhance the OBJECT_NAME parameter to support generic names

Enhanced with IBM i 7.4 SF99704 Level 10 and IBM i 7.3 SF99703 Level 22:
  1. *ALLAVL is an accepted special value on the OBJECT_SCHEMA parameter

Enhanced with IBM i 7.4 SF99704 Level 4 and IBM i 7.3 SF99703 Level 16:
  1. Many new columns are returned

Enhanced with IBM i 7.3 SF99703 Level 3 and IBM i 7.2 SF99702 Level 14

  • Add *ALLSIMPLE support for fast lookup of library names

Enhanced with IBM i 7.3:

  1.  Many new return columns have been added

Enhanced with IBM i 7.2 TR3:

  1.  Enhanced to find all object types
    Previously, the following object types were not found by OBJECT_STATISTICS():

    *COSD, *CTLD, *DEVD, *LIND, *MODD, *NWSD, *USRPRF


Enhanced with IBM i 7.2 TR2:
  1. Optional OBJECT_NAME parameter
  2. Addition of the TEXT column
  3. Addition of the SQL_OBJECT_TYPE column
  4. OBJLONGNAME column changed to return long names for SQL objects, where appropriate

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
12 April 2021

UID

ibm11128549