List physical and logical files for iSeries
Follow these steps to list iSeries physical and logical
files:
- On the Create Objects page, scroll down to the statement:
CREATE VIEW RDBI.TABLE_VIEW2
- In the "CREATE" statement, modify the "WHERE" clause by adding
a 'P' for physical files and an 'L' for
logical files. For example:
WHERE A.TABLE_TYPE IN ('T','V','P','L')
- Click OK to create the object.
