News
Abstract
The SYSFILES view contains information about database files.
The information returned is similar to the detail seen from the Display File Description (DSPFD) command and the Retrieve Database File Description (QDBRTVFD) API.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > QSYS2.SYSFILES
For complete detail, visit this IBM Documentation page: SYSFILES
Enhanced with IBM i 7.5 SF99950 Level 4 & IBM i 7.4 SF99704 Level 25:
- Addition of the BASED_ON_FILES column
Some examples for using QSYS2.SYSFILES include:
[{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]
Was this topic helpful?
Document Information
Modified date:
22 March 2025
UID
ibm16486897