Generating Edit and Code Tables › Stand-Alone Tables › Examples

Examples

The following examples demonstrate the use of DDDL statements to define and generate stand-alone tables.

Example 1

The following sample TABLE statement adds a stand-alone edit table of valid values to the dictionary; the search technique is linear and the table is unsorted:

ADD TABLE DEPTEDIT
TYPE IS EDIT VALID
SEARCH IS LINEAR
TABLE IS UNSORTED
VALUES ARE ( SHIPPING PERSONNEL ACCOUNTING
     MARKETING 'OFFICE SERVICES' )
GENERATE
          .

Example 2

The following sample TABLE statement adds a stand-alone edit table of valid values to the dictionary; the search technique is binary:

ADD TABLE NAMEEDIT
TYPE IS EDIT VALID
SEARCH IS BINARY
VALUES ARE
 ( ADAMS
   AGASSIZ
   BACH
     .
     .
     .

   XERXES
   YEATS
   ZENO )
GENERATE
 .

Example 3

The following sample TABLE statement adds a stand-alone code table to the dictionary; the search technique is linear and the table is unsorted:

ADD TABLE DEPTCODE
TYPE IS CODE
SEARCH IS LINEAR
TABLE IS UNSORTED
VALUES ARE
( 01          SHIPPING
  02          PERSONNEL
  03          ACCOUNTING
  04          MARKETING
  05         'OFFICE SERVICES'
  00          NOT FOUND
  NOT FOUND   MISSING  )
GENERATE
 .