Using the data of RTVDIRINF

Here are examples that display why the data is important or how you can use the data that is produced from each of the three tables.

For Table 1, you can make queries to create reports or statistics based on any of the fields within this table. PRTDIRINF does not include reports based on all of the fields. Instead, a subset will be used.
The data from Table 2 contains all the directories within the path specified in DIR parameter of the RTVDIRINF command. If you want to know specific attributes about the path name, for example the CCSID, language ID, or length, then this data is useful. Also, each directory stored in this table has a unique value, or index that identifies it. In Table 1, you can find the same field, QEZDIRIDX, that will tell you which objects belong to which directory. To find which objects belong to which directory, you can make a query using joins. For example, the following query statement selects the names of all objects existing in directory "/MYDIR":
```
SELECT QAEZDxxxxO.QEZOBJNAM FROM library_name/QAEZDxxxxD,
library_name/QAEZDxxxxO WHERE QAEZDxxxxD.QEZDIRNAM1 = '/MYDIR' AND
QAEZDxxxxD.QEZDIRIDX = QAEZDxxxxO.QEZDIRIDX
```
Table 3 is mostly used by the PRTDIRINF command to obtain specific data about RTVDIRINF runs. Examples of this are: The names of the tables created, the library where the tables reside, and the starting and ending time of processing. You might use this table to know when a RTVDIRINF was issued or what tables must be searched in order to query them.