Maintaining Application Components › Maintaining Tables › Defining and Maintaining Table Definitions

Defining and Maintaining Table Definitions

Defining a table requires you to fill in two panels. The first of these defines the actual table, the second specifies all the fields required for each entry in the table.

PROD----------------------- CAS : Table Description -----------------Page 1 of 2
 Command ===>                                                       Function=Add

 Appl ID .................. ___   Field name ............... ____________
 Field description ........ ____________________
 Edit type ................ TABLE (TABLE, OSATT, OSFLD, IMFLD or IMREC)
 For Edit type = TABLE:
    Validation exit ................. ________
    Sequence numbers ................ ___ (YES or NO)
    Load table? ..................... ___ (YES or NO)
    Max abbreviation length ......... ___ (3 - 8 or blank if none)
    Max full value length ........... ___ (3 - 20)
    Max description length .......... ___ (3 - 38 or blank if none)
 For Edit type = IMFLD or IMREC:
    InfoMaster category ............ ____
 For Edit type = IMREC:
    InfoMaster field ............... ____________
    InfoMaster description field ... ____________
 For Edit type = OSATT or OSFLD:
    Object Services Class ID ........ ____________
 For Edit type = NDBFL:

  F1=Help      F2=Split     F3=File      F4=Save
               F8=Forward   F9=Swap                               F12=Cancel

For information about the fields and options on this panel, press F1 (Help).

If the table has an Edit type of TABLE, you have the option of specifying additional input fields to appear on the Table Entry panel:

• If you do not require any extra data for the table entries, press F3 (File) to create the table definition. To cancel the create, press F12 (Cancel).
• To define extra input fields for the Table Entry panel, press F8 (Forward). The CAS : Table Text Fields panel is displayed.

  PROD---------------------- CAS : Table Text Fields -----------------Page 2 of 2
   Command ===>                                                    Function=Update
  
   Appl ID .................. TST
   Field name ............... TST001
  
  
                     Field   Text description        Length(4-38)
  
                       1     I/M Application_____    4___
                       2     Service Procedure___    8___
                       3     System Name_________    24__
                       4     Record Category_____    24__
                       5     ____________________    ____
                       6     ____________________    ____
                       7     ____________________    ____
                       8     ____________________    ____
                       9     ____________________    ____
                      10     ____________________    ____
  
  
  
    F1=Help      F2=Split     F3=File      F4=Save                   F6=Entries
    F7=Backward               F9=Swap                               F12=Cancel
  
  

For information about the fields and options on this panel, press F1 (Help).

After defining the validation table, press F3 (File). To cancel the table specification, press F12 (Cancel).