News
Abstract
The OBJECT_STATISTICS table function returns information about objects in a library.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.OBJECT_STATISTICS()
For complete detail, visit this IBM Documentation page: OBJECT_STATISTICS table function
Enhanced with IBM i 7.5 SF99950 Level 1:
- Add build identifier column
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:
- *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:
- 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:
- Many new return columns have been added
Enhanced with IBM i 7.2 TR3:
- 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:
- Optional OBJECT_NAME parameter
- Addition of the TEXT column
- Addition of the SQL_OBJECT_TYPE column
- 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":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
03 May 2022
UID
ibm11128549