During the definition process, you can adjust and readjust the table definition until it fits your needs exactly. Once the table is generated, you can redefine the table as your needs change.
You can change the definition of a generated table in several ways.
Table Definition
On the Table Definition screen (TDEF), you can change only the derivation information (sources, join fields, and join criteria); column definitions are automatically modified to reflect changes in the derivation information. You cannot change the table type; for example, you cannot redefine a view as a stored table.
Extended Table Definition
On the Extended Table Definition screen (XTAB), you can modify:
An ASF administrator can change the area in which the table is stored.
Column Definition
On the Column Definition screen (CDEF), you can modify:
When you modify columns, ASF updates the table definition upon regeneration. ASF performs data conversion for updates as shown below:
|
Update Command |
Column Criteria |
Keys |
Fields * |
Selection |
|---|---|---|---|---|
|
ADD |
X |
X |
|
X |
|
DELETE |
X |
X |
|
X |
|
MODIFY |
|
X |
X |
X |
|
* Length and data type |
||||
You can add and delete unique keys. If the unique key is a concatenated key, you should delete the entire key, not part of it. If you add a unique key, and a duplicate row is encountered, the regeneration of the table is interrupted and the duplicate row is written to the log.
Extended Column Definition
On the Extended Column Definition screen (XCOL), you can change the following information for stored tables:
For views, you can change the following information:
Extended Table Derivation
On the Extended Table Derivation screen (XDER), you can modify:
Note that changes to the derivation information are reflected automatically in the column definitions.
Extended Selection Definition
On the Extended Selection Definition screen (XSEL), you can define new selection criteria for the table, or change or delete selection conditions that have been previously defined.
Extended Key Definition
On the Extended Key Definition screen (XKEY), you can change the storage and display sequence of the table, define new index keys with duplicates allowed, or modify or delete existing keys.
Row-level Security
On the Row-Level Security screen (RSEC), you can change the security name and generic column names assigned to the table.
Redefinition Status
Modifying the definition of a generated table places the table in REDEFINITION status. You can continue to use the table through the Load Data and Display/Change Data functions of ASF, but the table will not reflect the changes you have made. The Select Data and Query functions are not available for tables in REDEFINITION status.
You can continue to access the table outside ASF through the generated subschema, but this is the previously generated subschema and it does not reflect the changes you have made to the table definition.
|
Copyright © 2014 CA.
All rights reserved.
|
|