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?
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.