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 QEZOBJNAM FROM library_name/QAEZxxxxO, library_name/QAEZxxxxD WHERE QEZDIRNAM1 = "/MYDIR" AND 
  library_name/QAEZxxxxO.QEZDIRIDX=library_name/QAEZxxxxD.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.

 

Parent topic:

Working with output of the RTVDIRINF and PRTDIRINF commands