I want to identify all the available source physical files (SRC-PF) in the IBM i (AS400) system.
Is there any CL command or SQL query available that I can refer to find all the source physical files present in AS400 in all libraries?
I want to identify all the available source physical files (SRC-PF) in the IBM i (AS400) system.
Is there any CL command or SQL query available that I can refer to find all the source physical files present in AS400 in all libraries?
Notifications
You can use the SQL query to find the source physical file in AS400.
Select * from QSYS.QADBXREF where DBXTYP = 'S'This query will fetch and list all the source physical files in the AS400 system.