Table Generation

When you generate a table through ASF, the following steps take place:

Record and element definitions are added to the data dictionary. The naming conventions are as follows:
- Records are named RFUR-nnnnnn-DATA, where nnnnnn is the table definition number.
- Element names are the Stored Column Name shown on the Extended Column Definition screen.
Record and set descriptions are added to the schema IDMSR (nnnnnn is the table definition number) as shown in the following table.

Name	Object	Description
RFUR-nnnnnn-DATA	record	The record type in which rows of the table are stored as record occurrences.
RFUR-nnnnnn-OOAK	record	The CA IDMS/DB-defined OOAK record.
RFUS-nnnnnn-SET	set	An unsorted indexed set defined if the storage sequence of the table is NEXT, PRIOR, FIRST, or LAST.
RFPS-nnnnnn-SET	set	An indexed set defined if the storage sequence of the table is designated by the key number of an index key.
RFFS-nnnnnn-yyyy	set	One for each fast access key defined on the Extended Key Definition screen (refer to the chapter "Extended Functions of ASF"). Yyyy refers to the field definition number for the column, assigned in the FDEFREC.
RFKS-nnnnnn-zzzz	set	One for each additional key defined on the Extended Key Definition screen that is not used as the storage sequence. Zzzz is the key number of the additional key.

A subschema (named RUnnnnnn) is generated consisting of:
- A logical record containing the elements shown in the following table.

Name	Description
ASF-RDEF-REC	The table definition record
RFUR-nnnnnn-OOAK	The system-defined OOAK record
RFUR-nnnnnn-DATA	The record used to store rows of the table
RFUR-nnnnnn-WORK	An IDD work record, included if any work fields are defined for the table

The logical record is named by modifying the table name to conform to COBOL naming conventions, as shown below.

Special characters and spaces are changed to hyphens:

Leading and trailing hyphens are deleted:

Lowercase letters are translated to uppercase letters:

Multiple repeating embedded hyphens are reduced to one hyphen:

Numbers in the first position are preceded by an R:

Names longer than 16 characters are truncated:

JOBS AND APPLICANTS becomes JOBS-AND-APPLICA

Logical-record paths, which allow an application programto OBTAIN, STORE, MODIFY, and ERASE occurrences of the logical record.

A map is created in which the columns defined for the table are the data fields for the map. The map is named RMnnnnnn (nnnnnn is the table definition number). This step can be suppressed at the user's discretion. If you suppress this step, step 5 is also suppressed.
A dialog that uses the subschema and map is generated to allow online access of the table through ASF. The dialog is named RDnnnnnn (nnnnnn is the table definition number). In addition to the subschema (RUnnnnnn) and map (RMnnnnnn), the dialog has the following components:
- ASF-PARM-REC—A parameter record included in every ASF-generated dialog
- The following Process modules.

Name	Description
RDnnnnnn-PREMAP	The premap process
RDnnnnnn-CLEAR	The response process for the [Clear] key
RDnnnnnn-ENTER	The response process for the [Enter] key
RDnnnnnn-PA1	The response process for the [PA1] key
RDnnnnnn-PF1	The response process for the [PF1] key
RDnnnnnn-PF2	The response process for the [PF2] key
RDnnnnnn-PF3	The response process for the [PF3] key

The first two steps above apply only to stored tables. For views, ASF performs steps 3 through 5 only.