Extended Functions of ASF › Specifying Underlying Table Characteristics › Limiting the Use of a Table

Limiting the Use of a Table

By default, when you generate a table through ASF, an online application is created that enables you to display, add, change, and delete data in the table. You can choose not to generate an application for the table, or you can limit the functions that can be performed by both the ASF-generated application and any other applications that use the table.

Prevent Table Generation

To instruct ASF not to generate an application for the table, change the Generate Map/Dialog field from YES (default) to NO. The table will not be available for use through the Load Data, Display/Change Data, and Select Data functions of ASF. The table can be loaded and updated through batch or online programs developed outside ASF, as well as through OnLine Query (CA OLQ) and CA Culprit.

Note: The Generate Map/Dialog field can also be used to generate an application for a table created outside ASF (for example, through OnLine Query or CA Culprit). Change the NO (the default for tables created outside ASF) to YES and regenerate the table.

Restrict Table Use

To restrict the functions that can be performed with the table, both through the ASF-generated application and applications developed outside ASF, use the following fields:

• Display Access— Enter NO to prevent users from displaying the table. The OBTAIN logical-record path is omitted from the generated subschema.
• Load Access— Enter NO to prevent users from loading data into the table. The STORE logical-record path is omitted from the generated subschema.
• Change Access— Enter NO to prevent users from modifying the table. The MODIFY logical-record path is omitted from the generated subschema.
• Erase Access— Enter NO to prevent users from deleting data from the table. The ERASE logical-record path is omitted from the generated subschema.

Since the above restrictions apply to the generated subschema, any applications that use that subschema, such as a DML program, are also restricted.

The remaining fields on the Extended Table Definition screen give information about a generated table and application.

For more information about fields on the Extended Table Definition screen ,see the chapter "Extended Screens"