Retrieving details about tables in batch mode

You can use batch mode to retrieve details about tables.

1. In the Option field on the Administration Menu panel, specify 1, and press Enter.
   The System Catalog panel is displayed.
2. Specify T, and press Enter.
   The Tables, Views, and Aliases panel is displayed.
3. Find the table whose details you want to retrieve in the Name field.
4. Choose one of the following methods:
   • To retrieve details about a single table, specify BET in the Sel column next to the object, and press Enter.
   • To retrieve details about all the tables, issue the BET command in the Command line, and press Enter.
   The JCL is generated. For more information, see Figure 1.

   The PARMS section shows parameter usage for tables, as shown in the following example:

   //PARMS    DD *                                                         
   TYPE='TB' QUAL='SYSIBM' NAME='DSN_PREDICAT_TABLE';                      
   TYPE='TB' QUAL='SYSIBM' NAME='DSN_PREDICATE_SELECTIVITY';               
   TYPE='TB' QUAL='DSN8BQRY' NAME='DSN_PREDICAT_TABLE';                    
   TYPE='TB' QUAL='DSN8BQRY' NAME='DSN_PREDICATE_SELECTIVITY'; 

5. Submit the job.