Extended Screens › Extended Table Definition Screen—XTAB

Extended Table Definition Screen—XTAB

Description

The Extended Table Definition screen allows you to control aspects of the table definition process that are usually handled automatically by the system. It also provides information about a table defined using ASF menus, so that the table can be used in another environment (for example, in a DML program).

The Extended Table Definition screen can be used by programmers and database administrative personnel for the following purposes:

• To assign a table to a particular area in the database
• To review table information supplied by the system
• To change access to stored tables

Use of this screen is optional; the user does not have to access the Extended Table Definition screen in order to define or use a table through ASF.

Access

You can access the Extended Table Definition screen in one of the following ways:

• Select the Extended Table Definition function from the Table Definition screen; you can select the function by pressing [PF4].
• Enter XTAB in the screen name field of any other screen.

Sample Screen

                                            CA
  XTAB   CA - Automatic System Facility          *Extended Table Definition*
  DC560501 MODIFY TABLE DEFINITION
  Table Name: JOB

     _ PF1 - Help                            _ PF4 - Extended Key Definition
     _ PF2 - Extended Table Derivation       _ PF5 - Row Level Security
     _ PF3 - Extended Selection Definition

  Area: IDMSR-AREA2

  Display Access..........: YES        Subschema: RU000239
  Load Access.............: YES        Map......: RM000239   Version:     1
  Change Access...........: YES        Dialog...: RD000239   Version:     1
  Erase Access............: YES
                                       Table Definition Length:   120
  Generate Map/Dialog.....: YES
                                       Date/Time Created......:mm/dd/yy 10:20:4
  C/ICMS Modify Option....: YES        Date/Time Last Updated.:mm/dd/yy 10:50:3

  C/ICMS Selective Update:  YES        Process Standard Area Data: YES

  Logical Record Name.....: JOB

Fields

Table Name

Displays the name of the table specified on the Activity Selection screen.

[PF1] - Help

Invokes the Help screen.

[PF2] - Extended Table Derivation

Invokes the Extended Table Derivation screen, which allows you to specify a complex table derivation.

[PF3] - Extended Selection Definition

Invokes the Extended Selection Definition screen, which allows you to select the data to be included in the table.

[PF4] - Extended Key Definition

Invokes the Extended Key Definition screen, which allows you to establish indexes for the table.

[PF5] - Row Level Security

Invokes the Row-level Security screen, which allows you to assign a security name and generic column names to your table.

Area

Contains the name of the database area in which the table's data is stored. An ASF administrator can assign the table to a particular area by entering the name of a valid area defined to ASF in this field.

Display Access

Controls the generation of an OBTAIN logical-record path in the ASF-generated subschema. YES is the default.

Load Access

Controls the generation of a STORE logical-record path in the ASF-generated subschema. YES is the default for stored tables; for views, this field is always NO and cannot be changed.

Change Access

Controls the generation of a MODIFY logical-record path in the ASF-generated subschema. YES is the default.

Erase Access

Controls the generation of an ERASE logical-record path in the ASF-generated subschema. YES is the default for stored tables; for views, this field is always NO and cannot be changed.

Generate Map/Dialog

Indicates whether the system automatically generates a screen format (map) and processing logic (dialog) for accessing the table. The default is YES. When the table is generated, you can access it online through ASF, using this map and dialog. Enter NO if you do not want ASF to generate an online application for using the table.

C/ICMS Modify Option

Displays the status of the table as it relates to the SAVE UPDATES option of supported PC software. When you request SAVE UPDATE from the PC, ASF acts as follows:

• If the row exists on the mainframe, the request is processed as a MODIFY by ASF.
• If the row doesn't exist on the mainframe, the request is processed as an ADD by ASF.

The valid values for this field are:

• YES—If the row doesn't exist on the mainframe, and the request came as a MODIFY from the PC, ASF is allowed to ADD the row.
• REJECT—If the row doesn't exist on the mainframe, and the request came as a MODIFY from the PC, ASF is not allowed to ADD the row.

C/ICMS Selective Update

Enter the status of the table as it relates to the selective update feature applicable to the supported PC software. When a table is to be used with the selective update feature, ASF generates and adds special code to the logical record. This code is generated automatically if the table has only one unique key. The possible values for this field are:

• YES—The table has only one unique key and therefore is eligible for selective update. ASF has generated the additional logical record code required to support a selective update.
• NO—Selective updates for the table are not allowed, and ASF is not to generate the additional logical record path code.
• INELIGIBLE—The table has more than one unique key, or it does not have a unique key; ASF will not generate the additional code.
• DISABLED—The table is eligible for selective update, and ASF has generated the additional code. You can change the field to this value and regenerate the table to temporarily suspend selective update activities. The modification of the field in this way does not cause a regeneration of the subschema, it only causes ASF to disallow selective update requests. To return to normal operations, change the field back to YES and regenerate the table.

Logical Record Name

Displays the name of the logical record defined for a stored table or view in the subschema.

Subschema

Displays the name of the subschema generated for the table. Subschema names are RUnnnnnn, where nnnnnn is the table definition number.

Map

Displays the name of the map generated for the table. Map names are RMnnnnnn, where nnnnnn is the table definition number.

Version

Displays the map version number.

Dialog

Displays the name of the dialog generated for the table. Dialog names are RDnnnnnn, where nnnnnn is the table definition number.

Version

Displays the dialog version number.

Table Definition Length

Displays the current length of the underlying logical record.

Date/Time Created

Shows the date and time the table definition was generated.

Date/Time Last Updated

Shows the date and time the table definition was last updated.

Process Standard Area Data

Indicates whether ASF will restructure the table when it regenerates the table and whether ASF will delete the table when it deletes the table definition. The default is YES. This field will only appear to those who have administrator authority:

• When a table is deleted
• When a table is regenerated

Enter NO if you do not want ASF to modify the table data when a table definition is regenerated or deleted.