Previous Topic: Database Specifications ScreenNext Topic: Process Modules Screen


Records and Tables Screen

The Records and Tables screen is used to associate a record with a dialog definition and to assign the New and Work record attributes.

New Attribute

The New attribute identifies records for which new buffers are allocated and initialized when the dialog executes at runtime. Previously established buffers for records assigned the New attribute are retained but are not available to the dialog. A record that is assigned the New attribute must be known to the dialog as a subschema, map, or work record.

Work Attribute

The Work attribute associates a record with a dialog as a work record. The CA ADS runtime system allocates buffers for work records; in this way, records with the Work attribute establish working storage for a dialog. A record must be defined in the data dictionary before it can be associated with a dialog as a work record.

Records are dissociated from a dialog definition by:

Up to 7 records can be specified on one page of the Records and Tables screen. Using the [PF8], additional pages are displayed.

Sample Screen

Records and Tables Page 1 of 1 Dialog NAME1 Version 1 Name Version Work New copy Drop 1. AA 1 / _ _ 2. AA 1 / _ _ 3. _____________________________________ ____ _ _ _ 4. _____________________________________ ____ _ _ _ 5. _____________________________________ ____ _ _ _ 6. _____________________________________ ____ _ _ _ 7. _____________________________________ ____ _ _ _ DC498240 Record 2 is defined twice as a work record. Enter F1=Help F3=Exit F4=Prev F5=Next F7=Bkwd F8=Fwd

Field Descriptions

Dialog

Displays the name of the current dialog, as specified on the Main Menu screen. This field is protected.

Version

Specifies the version number, in the range 1 through 9999, of the current dialog. This field is protected.

Name

The 1- to 32-charcter name of each record assigned the WORK and/or NEW COPY attribute. Records associated with the dialog's map or subschema will be automatically associated with the dialog and need not be listed. If the dialog is to use its own copy of a record or if the dialog must distinguish between logical records or between a logical record and a database record, the required record or logical record can be named.

The value of the Name field can also be the 1- to 18-character schema name, followed by a period (.), followed by the 1- to 18-character table name of every table to be assigned as a host variable of an SQL command.

Version

Specifies the version number, in the range 1 through 9999, of the named record. The default version number is the system version default version number, as specified at system generation. If no system number is specified, the default version number is 1.

Work

Associates the Work attribute with the corresponding record. Records with the Work attribute are available to the dialog as working storage at runtime.

The application developer associates the Work attribute with a record by entering a nonblank character in the Work field corresponding to the applicable record.

If no attribute is specified when a record name is entered, Work is assigned as the default. If New is specified for a record, Work is automatically unassigned.

To remove the Work attribute from a record, the application developer places a nonblank character in the Drop column opposite the record to be dissociated.

New Copy

Associates the New attribute with the corresponding record. Records with the New attribute are allocated new record buffers when the dialog executes at runtime.

The application developer associates the New attribute with a record by entering a nonblank character in the New field corresponding to the applicable record. To remove the New attribute from a record, the application developer places a nonblank character in the Drop column opposite the record to be dissociated.

Drop

Removes the record from its association with the dialog, but does not delete the record definition from the dictionary.