Accessing the data of RTVDIRINF

 

There exist several options for accessing the data in the tables.

Listed below are ways that you can access the data created by the Retrieve Directory Information (RTVDIRINF) command:

• Using the Print Directory Information (PRTDIRINF) command

  This command is used to print directory information about objects and directory information in the integrated file system. The information it will print is already stored in the database file specified by the user in the RTVDIRINF command.

• Using any program or command provided by IBM that can run queries over a DB2^® table on the i5/OS^® operating system.

  Some of the more common tools are the Start SQL Interactive Session (STRSQL) command and the iSeries™ Navigator. For example, if you want to select objects in a specific path (previously collected by the RTVDIRINF command) that have an allocation size larger than 10 KB, you can run a query like this:

  SELECT QEZOBJNAM, QEZALCSIZE FROM library_name/QAEZDxxxxO WHERE 
  QEZALCSIZE > 10240

• You can make your own programs and access the database tables by using any valid DB methods.

 

Parent topic:

Working with output of the RTVDIRINF and PRTDIRINF commands

 

Related information

Print Directory Information (PRTDIRINF) command
Start SQL Interactive Session (STRSQL) command
Embedded SQL programming
SQL call level interface