<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<!--
Copyright (c) 2006 UGS Corp.

All Rights Reserved.

This software and related documentation are proprietary to UGS Corp.
-->
<html>
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>DBDICT</title>
      <script language="javaScript">
        abridged="false";
        displayConditions=new Array();
      </script>
      <link type="text/css" href="../css/main_styles.css" rel="stylesheet">
   </head>
   <body class="bodydocs" onload="top.pageLoader()" bgcolor="#FFFFFF">
      <hr noshade="true">
      <div class="title_refTopic" id="xps10_pagetitle">DBDICT </div>
      <hr noshade="true">
      <h4 class="refClassification">Prints Database Directory Tables: </h4>
      <p class="para_refTopic">Prints database directory tables.</p>
      <div class="title_refCategory">Database Directory Tables </div>
      <div class="refCategoryContent">
         <ul>
            <li>
               <p class="para_item">Data blocks described by an NDDL DATABLK statement. </p>
            </li>
            <li>
               <p class="para_item">Parameters described by an NDDL PARAM statement. </p>
            </li>
            <li>
               <p class="para_item">All unique paths (KEYs) and their qualifiers values. </p>
            </li>
            <li>
               <p class="para_item">Qualifiers and their current values. </p>
            </li>
            <li>
               <p class="para_item">Data blocks not described by an NDDL DATABLK statement. </p>
            </li>
            <li>
               <p class="para_item">Parameters not described by an NDDL PARAM statement. </p>
            </li>
            <li>
               <p class="para_item">Project and version information. </p>
            </li>
         </ul>
      </div>
      <div class="title_refCategory">Basic Format: </div>
      <div class="refCategoryContent">
         <p class="para_refCategory">The basic format of DBDICT specifies which tables to print and prints all items (data blocks and parameters) found in the directory. Also, the attributes (colnames) to be printed and the print format are predefined. Note that more than one table may be specified on the same DBDICT statement. </p>
         <p align="center"><img align="bottom" src="graphics/fms-ufig05.gif"></p>
      </div>
      <div class="title_refCategory">Examples: </div>
      <div class="refCategoryContent"><pre class="indent">DBDICT
DBDICT PARAM PROJVERS</pre></div>
      <div class="title_refCategory">Full Format: </div>
      <div class="refCategoryContent">
         <p class="para_refCategory">The full format permits the selection of items by name and/or by the WHERE describer.  The full format also permits the attributes to be printed using the SELECT describer.  In addition, the print format can be specified with the SORT, FORMAT, and LABEL describers.  Note that the full format only allows the specification of a single table on a DBDICT statement. </p>
         <p align="center"><img align="bottom" src="graphics/fms-ufig06.gif"></p>
         <table width="100%" align="center">
            <colgroup span="1">
               <col span="1" width="17.88*">
               <col span="1" width="82.12*">
            </colgroup>
            <tbody>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">FORMAT </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">(FWIDTH = w [.d]  DWIDTH = w [.d]  AWIDTH = a  IWIDTH = i, </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">&nbsp; </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">LWIDTH = k  COLSPACE = c  VALUE = w, </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">&nbsp; </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">colname = col-width, . . .), </p>
                  </td>
               </tr>
            </tbody>
         </table><br><p align="center"><img align="bottom" src="graphics/fms-ufig07.gif"></p>
         <p align="center"><img align="bottom" src="graphics/fms-ufig08.gif"></p>
      </div>
      <div class="title_refCategory">Describers:</div>
      <div class="refCategoryContent">
         <table cellpadding="10" width="100%" align="center">
            <colgroup span="1">
               <col span="1" width="23.21*">
               <col span="1" width="76.79*">
            </colgroup>
            <thead>
               <tr>
                  <th align="left" colspan="1" rowspan="1">
                     <p class="para_th"><b class="uiTerm">Describer </b></p>
                  </th>
                  <th align="left" colspan="1" rowspan="1">
                     <p class="para_th"><b class="uiTerm">Meaning </b></p>
                  </th>
               </tr>
            </thead>
            <tbody>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">DATABLK </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print the data blocks.  datablk-list specifies a list of NDDL-defined data blocks separated by commas.  If LOCAL is specified, the non-NDDL-defined data blocks are printed. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">PARAM </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print the parameter table. param-list specifies a list of parameters separated by commas.  If LOCAL is specified, the non-NDDL-defined parameters are printed. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">PROJVERS </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print the project-version table. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">QUALIFIERS </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print the qualifier table. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">QUALCURR </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print the current values of the qualifiers.  SORT is ignored. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">where-expr </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Logical expression that specifies the desired values of colnames described below.  For example, WHERE(VERSION=4 AND SEID &lt; &gt; 2 AND SEID &gt; 0) selects all items under version 4 for all values of SEID greater than 0 except 2.  See the beginning of this section for a further description.  The default for VERSION is the last version, and PROJECT is the current project.  The default for qual is *, which is all qualifier values found on the database.  See also Remark <a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref98291');return(false);">15-12. </a></p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">SELECT </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies a list of column names to be printed.  The order of the specified colnames will be printed from left to right.  If a colname is not specified, then all columns will be printed. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">colname </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Column name. colname specifies a particular attribute of the database item; such as, data block name (NAME), creation date (CDATE), number of blocks (SIZE), or qualifier name (SEID, SPC, etc.).  The allowable colnames are given in the Remarks. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">col-label </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">The label to be printed above the column identified by colname.  The default for col-label is the colname. col-label may not be specified for colnames QUALSET, QUALALL, and TRAILER. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">FWIDTH=w.d </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for single-precision real numbers in real and complex qualifiers.  (Integers:  w &gt; 0 and d &gt; 0, Default = 12.5) </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">DWIDTH=w.d </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for double-precision real numbers in real and complex qualifiers.  (Integers:  w &gt; 0 and d &gt; 0, Default = 17.10) </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">AWIDTH=a </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for character string qualifiers.  Character strings are printed with enclosing single quotation marks, even if the string is blank.  (Integer &gt; 0, Default = 8) </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">IWIDTH=i </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for integer qualifiers.  (Integer &gt;  0.) See Remarks for defaults. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">LWIDTH=k </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for logical qualifiers. Logical values are printed as either &ldquo;T&rdquo; for TRUE or &ldquo;F&rdquo; for FALSE.  (Integer &gt;  0, Default = 1) </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">COLSPACE=c </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default number of spaces between columns.  (Integer &gt;  0) See Remarks for defaults. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">VALUE=w </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies the default width for parameter values.  The values are printed as character strings with left justification.  (Integer &gt; 0, Default = 40) </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">col-width </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">The print width of the data under colname or qual-name.  For real numbers, specify w.d where w is the width of the field and d is the number of digits in the mantissa.  For integers and character strings, specify w where w is the width of the field.  col-width may not be specified for colnames QUALSET, QUALALL, and TRAILER. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">SORT </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Specifies how the rows are sorted.  The sort is performed in order according to each colname specified in the list.  A &ldquo;D&rdquo; following the colname causes the sort to be in descending order.  An &ldquo;A&rdquo; following the colname causes the sort to be in ascending order.  Colnames QUALSET, QUALALL, and TRAILER may not be specified under SORT.  Each colname specified in SORT must be separated by commas. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">page-title </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">A title to be printed on each page of the directory output. </p>
                  </td>
               </tr>
               <tr>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">RIGHT, CENTER, LEFT </p>
                  </td>
                  <td align="left" colspan="1" rowspan="1" valign="top">
                     <p class="para_td">Print justification of the page title. </p>
                  </td>
               </tr>
            </tbody>
         </table><br></div>
      <div class="title_refCategory">Remarks: </div>
      <div class="refCategoryContent">
         <ol type="1" start="1">
            <li>
               <p class="para_item">DBDICT prints seven different tables according to a default or a user-defined format.  The tables are: </p><a name="ref58424"></a><div class="title_tableWrapper">Table 2-1. DBDICT Tables </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="20*">
                     <col span="1" width="32*">
                     <col span="1" width="30*">
                     <col span="1" width="16*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Describer </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description  </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default Page-Title </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">See Remark </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABLK </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Data blocks described by a NDDL DATABLK statement. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NDDL DATABLOCKS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#refTJLQif8joan');return(false);">15-2. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PARAM </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameters described by a NDDL PARAM statement. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NDDL PARAMETERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref55545');return(false);">15-3. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALCURR </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Current Qualifiers and their values. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CURRENT QUALIFIERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref98541');return(false);">15-4. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALIFIERS </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Qualifiers and their values for each key number. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALIFIERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref61129');return(false);">15-5. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABLK(LOCAL) </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Data blocks not described by a NDDL DATABLK statement. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">LOCAL DATABLOCKS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref12887');return(false);">15-6. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PARAM(LOCAL) </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameters not described by a NDDL PARAM statement. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">LOCAL PARAMETERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref32860');return(false);">15-7. </a></p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJVERS </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Project-Version. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJECT-VERSION </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref44939');return(false);">15-8. </a></p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><p class="para_item">If DBDICT is specified without any describers then the NDDL Data blocks Table will be printed.  See Remark <a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#refTJLQif8joan');return(false);">15-2. </a></p>
               <p class="para_item">DATABLK(LOCAL) and PARAM(LOCAL) produce no output, and QUALCURR produces the default values specified on the NDDL QUAL statement. </p>
               <p class="para_item">The defaults and allowable colnames for SELECT, FORMAT, SORT, and LABEL depend on the table.  The defaults are described in the following remarks and tables. </p>
            </li>
            <li><a name="refTJLQif8joan"></a><p class="para_item">The default print of the NDDL Data Blocks Table is obtained by: </p><pre class="indent">DBDICT</pre><p class="para_item">or </p><pre class="indent">DBDICT DATABLK</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT DATABLK ,
     SELECT(NAME,DATABASE,DBSET,PROJ,VERS,CDATE,CTIME,
          SIZE,KEY,PURGED=&rsquo;PU&rsquo;,EQUIVD=&rsquo;EQ&rsquo;,
          POINTER=&rsquo;FILE&rsquo;,QUALSET) ,
     FORMAT(NAME=8,DBSET=8,CDATE=6,CTIME=6,SIZE=5,
          KEY=4 ,PURGED=4,EQUIVD=4,POINTER=8,
          IWIDTH=5,COLSPACE=1) ,
     SORT(PROJ=A,VERS=A,DBSET=A,NAME=A) ,
     LABEL(&rsquo;NDDL DATABLOCKS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="left"><img align="bottom" src="graphics/fms-fig01.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT DATABLK Example </div>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref41331');return(false);">Table 2-2</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers. 
               </p><a name="ref41331"></a><div class="title_tableWrapper">Table 2-2. DBDICT DATABLK Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="17*">
                     <col span="1" width="15*">
                     <col span="1" width="24*">
                     <col span="1" width="38*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description  </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJECT </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">40 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJECT NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Project name defined by PROJECT statement </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJ </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJ NO </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Project number associated with PROJECT </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VERSION </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Version number </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CDATE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CDATE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Creation date </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CTIME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CTIME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Creation time </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABASE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABASE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">MASTER DBset name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBSET </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBset name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RDATE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RDATE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Revision date </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RTIME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RTIME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Revision time </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SIZE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">5 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SIZE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Number of blocks </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qual-name </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Qualifier name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Key number </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">i-th word in the trailer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRAILER </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All 10 trailer words </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EXTNAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EXTNAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Extended name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EQUIVD </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EQ </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Equivalenced flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PURGED </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PU </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Purged flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EQFLAG </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EF </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Scratch equivalenced flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SCRFLAG </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SF </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Scratch DBSET flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Directory pointer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBENTRY </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBENTRY </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Database entry pointer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">FEQCHAIN </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">FEQCHAIN </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Forward equivalence chain </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">BEQCHAIN </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">BEQCHAIN </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Backward equivalence chain </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBDIR20 </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">9 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBDIR(20) </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Directory word 20 </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALALL </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All qualifiers </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Predefined subset of all qualifiers </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><table border="0">
                  <tr>
                     <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
                     <td valign="bottom" align="left" width="100%">
                        <div class="para_note">
                           <p class="para_note_body">Default widths for qualifiers are DWIDTH=17.10, IWIDTH=5, LWIDTH=1, AWIDTH=8, and FWIDTH=12.5. </p>
                        </div>
                     </td>
                  </tr>
               </table>
            </li>
            <li><a name="ref55545"></a><p class="para_item">The default print of the NDDL Parameter Table is obtained by: </p><pre class="indent">DBDICT PARAM</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT PARAM,
     SELECT(NAME,DATABASE,DBSET,PROJ,VERS,CDATE,CTIME,
          KEY,VALUE,QUALSET),
     FORMAT(NAME=8,DATABASE=8,DBSET=8,CDATE=6,CTIME=6,
          KEY=4,VALUE=40,IWIDTH=5,COLSPACE=1),
     SORT(PROJ=A,VERS=A,DBSET=A,NAME=A),
     LABEL(&rsquo;NDDL PARAMETERS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="center"><img align="bottom" src="graphics/fms-fig02.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT PARAM Example </div>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref39389');return(false);">Table 2-3</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers. 
               </p><a name="ref39389"></a><div class="title_tableWrapper">Table 2-3. DBDICT PARAM Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="18.12*">
                     <col span="1" width="18.81*">
                     <col span="1" width="22.03*">
                     <col span="1" width="41.03*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJECT </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">40 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJECT NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Project name defined by PROJECT statement </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJ </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">5 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PROJ </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Project number associated with PROJECT </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VERS </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VERS </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Version number </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CDATE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CDATE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Creation date </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CTIME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">CTIME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Creation time </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABASE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DATABASE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">MASTER DBset name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBSET </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">DBset name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RDATE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RDATE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Revision date </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RTIME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">6 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">RTIME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Revision time </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Directory pointer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VALUE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">40 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VALUE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter value </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">4 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Key number </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qual-name </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Qualifier name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALALL </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All qualifiers </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Predefined subset of all qualifiers </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><table border="0">
                  <tr>
                     <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
                     <td valign="bottom" align="left" width="100%">
                        <div class="para_note">
                           <p class="para_note_body">Default widths for qualifiers are DWIDTH=17.10, AWIDTH=8, IWIDTH=5, LWIDTH=1, and FWIDTH=12.5. </p>
                        </div>
                     </td>
                  </tr>
               </table>
            </li>
            <li><a name="ref98541"></a><p class="para_item">The default print of the Qualifier Table is obtained by: </p><pre class="indent">DBDICT QUALIFIERS</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT QUALIFIERS ,
     SELECT(KEY QUALALL) ,
     FORMAT(DWIDTH=17.10 AWIDTH=8 IWIDTH=5 LWIDTH=1 ,
          FWIDTH=12.5  COLSPACE=2) SORT(KEY=A) ,
     LABEL(&rsquo;QUALIFIERS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="center"><img align="bottom" src="graphics/fms-fig03.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT QUALIFIERS Example </div>
               <p class="para_item">QUALALL selects all qualifiers to be printed.  The qualifiers will be printed in alphabetic order.  QUALSET selects the qualifiers SEID, PEID, SPC, MPC, LOAD, and METH to be printed. </p>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref54391');return(false);">Table 2-4</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers.  QUALALL and QUALSET may not be specified in the FORMAT or SORT describers.  The qualifier names and values are not printed one per row, but rather from left to right as one logical line that is allowed to wrap after 132 columns. 
               </p><a name="ref54391"></a><div class="title_tableWrapper">Table 2-4. DBDICT QUALIFIERS Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="19*">
                     <col span="1" width="16*">
                     <col span="1" width="24*">
                     <col span="1" width="38*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">5 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">KEY </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Key number </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qual-name </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Qualifier name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALALL </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All qualifiers </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Predefined subset of all qualifiers </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><table border="0">
                  <tr>
                     <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
                     <td valign="bottom" align="left" width="100%">
                        <div class="para_note">
                           <p class="para_note_body">Default widths for qualifiers are DWIDTH=17.10, IWIDTH=5, LWIDTH=1, and FWIDTH=12.5.  AWIDTH defaults to the length specified on the QUAL statement in the NDDL sequence. </p>
                        </div>
                     </td>
                  </tr>
               </table>
            </li>
            <li><a name="ref61129"></a><p class="para_item">The default print of the Current Qualifier Table is obtained by: </p><pre class="indent">DBDICT QUALCURR</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT QUALCURR SELECT(QUALALL),
     FORMAT(AWIDTH=8,IWIDTH=5,LWIDTH=1,COLSPACE=2),
     LABEL=(&rsquo;CURRENT QUALIFIERS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="left"><img align="bottom" src="graphics/fms-fig04.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT QUALCURR Example </div>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref47232');return(false);">Table 2-5</a> gives the allowable colnames along with a description that may be specified in the SELECT describers. 
               </p><a name="ref47232"></a><div class="title_tableWrapper">Table 2-5. DBDICT QUALCURR Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="17.94*">
                     <col span="1" width="17.58*">
                     <col span="1" width="22.14*">
                     <col span="1" width="42.34*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description  </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qual-name </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Qualifier name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALALL </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All qualifiers </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">QUALSET </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">See Note. </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">qualifier name </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Predefined subset of all qualifiers </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><table border="0">
                  <tr>
                     <td valign="top" align="left"><img align="left" src="../graphics/note.gif" alt="Note" title="Note"></td>
                     <td valign="bottom" align="left" width="100%">
                        <div class="para_note">
                           <p class="para_note_body">Default widths for qualifiers are DWIDTH=17.10, IWIDTH=5, LWIDTH=1, and FWIDTH=12.5.  AWIDTH defaults to the length specified on the QUAL statement in the NDDL sequence. </p>
                        </div>
                     </td>
                  </tr>
               </table>
            </li>
            <li><a name="ref12887"></a><p class="para_item">The default print of the Local Data Block Table is obtained by: </p><pre class="indent">DBDICT DATABLK(LOCAL)</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT DATABLK(LOCAL),
     SELECT(NAME,SUBDMAP,SIZE=&rsquo;BLOCKS&rsquo;,PURGED=&rsquo;PU&rsquo;,
          EQUIVD=&rsquo;EQ&rsquo;,POINTER,TRL1,TRL2,TRL3,TRL4,
          TRL5,TRL6,TRL7),
     FORMAT(NAME=8,SUBDMAP=8,IWIDTH=8,COLSPACE=2),
     SORT(NAME=A) LABEL(&rsquo;LOCAL DATABLOCKS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="center"><img align="bottom" src="graphics/fms-fig05.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT DATABLK(LOCAL) Example </div>
               <p class="para_item">TRLi specifies the data block trailer word i where 1 &le; i &le; 10.  TRAILER selects all 10 data block trailer words. </p>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref14879');return(false);">Table 2-6</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers. 
               </p><a name="ref14879"></a><div class="title_tableWrapper">Table 2-6. DBDICT DATABLK(LOCAL) Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="23.09*">
                     <col span="1" width="18.84*">
                     <col span="1" width="21.73*">
                     <col span="1" width="36.33*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SUBDMAP </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SUBDMAP </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SubDMAP name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SIZE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">BLOCKS </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Number of blocks </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EQUIVD </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EQ </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Equivalenced flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PURGED </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">PU </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Scratch flag </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">POINTER </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Directory pointer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">i-th word in the trailer </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRAILER </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">TRLi </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">All 10 trailer words </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EXTNAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">EXTNAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Extended name </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br></li>
            <li><a name="ref32860"></a><p class="para_item">The default print of the Local Parameter Table is obtained by: </p><pre class="indent">DBDICT PARAM(LOCAL)</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT PARAM(LOCAL) SELECT(NAME,SUBDMAP,VALUE),
     FORMAT(COLSPACE=4,VALUE=40,AWIDTH=8),
     SORT(NAME=A) LABEL(&rsquo; LOCAL PARAMETERS&rsquo; CENTER)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="center"><img align="bottom" src="graphics/fms-fig06.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT PARAM(LOCAL) Example </div>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref62608');return(false);">Table 2-7</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers. 
               </p><a name="ref62608"></a><div class="title_tableWrapper">Table 2-7. DBDICT PARAM(LOCAL) Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="21.66*">
                     <col span="1" width="22.34*">
                     <col span="1" width="22.57*">
                     <col span="1" width="33.43*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description  </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SUBDMAP </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">8 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SUBDMAP </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">SubDMAP name </p>
                        </td>
                     </tr>
                     <tr>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VALUE </p>
                        </td>
                        <td align="center" colspan="1" rowspan="1">
                           <p class="para_td">40 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">VALUE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1" valign="top">
                           <p class="para_td">Parameter name </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br></li>
            <li><a name="ref44939"></a><p class="para_item">The default print of Project-Version Table is obtained by: </p><pre class="indent">DBDICT PROJVERS</pre><p class="para_item">and is equivalent to: </p><pre class="indent">DBDICT PROJVERS ,
     SELECT(PROJECT=&rsquo;PROJECT NAME&rsquo;,PROJ=&rsquo;PROJ NO.&rsquo; ,
          VERS=&rsquo;VERSION&rsquo;,DELFLG=&rsquo;DELETED&rsquo; ,
          CDATE=&rsquo;CREATION DATE&rsquo; CTIME=&rsquo;CREATION
          TIME&rsquo;) ,
     FORMAT(PROJECT=40,PROJ=10,VERS=10,DELFLG=7,
          COLSPACE=1 ,CDATE=13,CTIME=13) ,
     LABEL(&rsquo;PROJECT-VERSION&rsquo;,CENTER) ,
          SORT(PROJ=A,VERS=A)</pre><p class="para_item">and looks like: </p>
               <div class="figure">
                  <p align="left"><img align="bottom" src="graphics/fms-fig07.gif"></p>
               </div>
               <div class="title_figure">Figure. DBDICT PROJVERS Example </div>
               <p class="para_item"><a class="links" href="javascript:void(0)" onclick="top.openFile('QRG/03ref33329_12.html#ref20318');return(false);">Table 2-8</a> gives the allowable colnames along with a description that may be specified in the FORMAT, SELECT, and SORT describers. 
               </p><a name="ref20318"></a><div class="title_tableWrapper">Table 2-8. DBDICT PROJVERS Colnames </div>
               <table border="1" width="100%" align="center">
                  <colgroup span="1">
                     <col span="1" width="13*">
                     <col span="1" width="13*">
                     <col span="1" width="26*">
                     <col span="1" width="43*">
                  </colgroup>
                  <thead>
                     <tr>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">colname </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-width </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Default col-label </b></p>
                        </th>
                        <th align="center" colspan="1" rowspan="1">
                           <p class="para_th"><b class="uiTerm">Description </b></p>
                        </th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">PROJECT </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">40 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">PROJECT NAME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Project name defined by PROJECT statement </p>
                        </td>
                     </tr>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">PROJ </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">10 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">PROJ NO </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Project number associated with PROJECT </p>
                        </td>
                     </tr>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">VERS </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">10 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">VERSION </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Version number </p>
                        </td>
                     </tr>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">DELFLG </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">7 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">DELETED </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Flag indicating whether this project/version has been deleted by the RESTART NOKEEP or DBCLEAN statements. </p>
                        </td>
                     </tr>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">CDATE </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">13 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">CREATION DATE </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Creation date </p>
                        </td>
                     </tr>
                     <tr valign="top">
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">CTIME </p>
                        </td>
                        <td colspan="1" rowspan="1">
                           <p class="para_td">13 </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">CREATION TIME </p>
                        </td>
                        <td align="left" colspan="1" rowspan="1">
                           <p class="para_td">Creation time </p>
                        </td>
                     </tr>
                  </tbody>
               </table><br><p class="para_item">CDATE is printed as YYMMDD where YY, MM, and DD are the year, month, and date, respectively.  CTIME is HHMMSS where HH, MM, and SS are the hour, minute, and second, respectively. </p>
            </li>
            <li>
               <p class="para_item">If a parameter or qualifier value is defined to be character string, then the value will be printed with enclosing single quotation marks.  Blank strings will also be printed with single quotation marks. </p>
            </li>
            <li>
               <p class="para_item">If a given qualifier is not in the path of a given data block or parameter, then blank spaces will be printed. </p>
            </li>
            <li>
               <p class="para_item">A line will wrap if additional columns need to be printed and not enough space is available on the output.  The first column of each additional line is to be indented by the width of the first column printed for the entry. </p>
            </li>
            <li><a name="ref98291"></a><p class="para_item">The where-expr has the following rules: </p>
               <ul>
                  <li>
                     <p class="para_item">If the where-expr specifies a colname that is not assigned to the data block or parameter, then no directory information will be printed for that data block or parameter.  For example, given that SPC is not a qualifier for KGG, then the following DBDICT statement will produce no output: </p><pre class="indent">DBDICT DATABLK=KGG WHERE(SPC=10)</pre></li>
                  <li>
                     <p class="para_item">If the where-expr does not specify a colname that is assigned to the data block (or parameter), then the qualifier is wildcarded.  For example, given that SEID is a qualifier for KAA, then the following DBDICT statements are equivalent: </p><pre class="indent">DBDICT DATABLK=KAA
DBDICT DATABLK=KAA WHERE(SEID = *)</pre></li>
               </ul>
            </li>
            <li>
               <p class="para_item">A colname specified in the where-expr must be specified in the SELECT clause if the SELECT clause is also specified. </p>
            </li>
         </ol>
      </div>
      <div class="title_refCategory">Examples: </div>
      <div class="refCategoryContent">
         <ol type="1" start="1">
            <li>
               <p class="para_item">Print the Project Version Table with a title. </p><pre class="indent">DBDICT  PROJVERS SORT(PROJ,VERSION) LABEL(&rsquo;PROJECT
     VERSION TABLE&rsquo; LEFT)</pre></li>
            <li>
               <p class="para_item">Print a directory of all data blocks qualified with PEID=10 or SEID=10.  Print columns for the NAME and DBSET, and the qualifiers SPC, MPC, and LOAD. </p><pre class="indent">DBDICT  DATABLK SELECT(NAME,SPC,MPC,LOAD,DBSET,SIZE,
          SEID,PEID) ,
     SORT(NAME,SIZE=D)  WHERE(SEID=10 OR PEID=10)</pre></li>
         </ol>
      </div>
   </body>
</html>