The following syntax is used to generate a statement for
each exported Edit Definition.
Keywords
The
keywords correspond to values that can be specified for an Edit Definition.
- ED identifier.name
- The name of the Edit Definition, specified in two
parts (identifier.name), is required following
the CREATE ED keyword.
- DESC //description//
- A description of the Edit Definition, delimited
by double slashes.
- DEFQUAL defaultqualifier
- The name of the default qualifier. The default qualifier
applies to table names that are not fully qualified.
- START starttable
- The Start Table for the Edit Definition. The DB
Alias and Creator ID for the table name are included only if they
differ from the Default Qualifier.
- AD adname
- The full two-part name of the Named Access Definition
being used.
- LOCALAD (addef)
- A full definition of the Local Access Definition
being used, contained in parentheses, follows this keyword. The syntax
and parameters for the definition of a Local Access Definition are
identical to those for a standalone Access Definition.
- MODE {E|B|O}
- The default Edit Definition mode to apply to newly
added tables.
- E
- Edit
- B
- Browse
- O
- Browse Only
- SIDEVIEW {Y|N}
- The default Edit Definition table display format.
- Y
- View in side label format.
- N
- View in columnar format (default).
- DISPLAY_ATTRS {Y|N}
- The default for displaying column attributes in
columnar mode.
- Y
- Display attributes.
- N
- Do not display attributes (default).
- DISPLAY_DELETED {Y|N}
- The default for displaying deleted rows.
- Y
- Display deleted rows (default).
- N
- Do not display deleted rows.
- WARN_DELETE {Y|N}
- The default for notifying the user before a cascade
delete is about to occur for one or more tables other than the table
for which the delete operation was requested.
- Y
- Display warning (default).
- N
- Do not display warning.
- DISPLAY_ROWS nn
- The default for the number of rows to be displayed
for tables that have been joined to subordinate tables. The default
number is 1; the valid range is 1-999.
- UNDOLEVELS nn
- The default for the number of undo levels per table
row. The default number is 5; the valid range is 1-20.
- VAR_PROMPT {Y|N}
- The default for prompting for variable values when
the Edit Definition is based on an Access Definition that contains
variables.
- Y
- Prompt for variables.
- N
- Do not prompt for variables (default).
- VAR (name,value)
- The name and the value for each variable.
- RETAIN_SELCRIT {Y|N}
- Indicator for applying selection criteria each time
the table is self-referenced while browsing or editing data.
Tables Keywords
There
is a TABLE entry for every table on the Table List for the
Edit Definition. The set of keywords for each table is enclosed in
parentheses following the keyword “TABLE.” The following keywords
have the same meaning as above, but apply to the specific table: MODE,
SIDEVIEW, DISPLAY_ATTRS, DISPLAY_DELETED, WARN_DELETE, DISPLAY_ROWS
Note: In
addition to the keywords mentioned above, the table also contains
grid-related keywords. Grid-related keywords define column ordering,
width, visibility, and locking, as specified by the user prior to
saving the Edit Definition. Grid-related keywords should not be modified.
- COL_ORDER // ###…//
- Column order for tables in columnar grid format.
- COL_WIDTHS // ###…//
- Column widths for tables in columnar grid format.
- COL_VISIBLE // ###…//
- Column visibility for tables in columnar grid format.
- COL_LOCKED // ###…//
- Column locking for tables in columnar grid format.
- SIDE_COL_ORDER // ###…//
- Column order for tables in side label grid format.
- SIDE_COL_WIDTHS // ###…//
- Column widths for tables in side label grid format.
- SIDE_COL_VISIBLE // ###…//
- Column visibility for tables in side label grid
format.
- SIDE_COL_LOCKED // ###…//
- Column locking for tables in side label grid format.
The following keywords pertain to
joined tables:
- OWNER [ [dba.cid.] ] tablename
- The name of the table to which the current table
is joined. If the current table is the Start Table, this keyword will
not exist. The joined table name must be fully qualified if the table
is from a different database or Creator ID.
- TBLID n
- For all tables except the Start Table, number to
indicate the parent table instance used for joining.
- CONSTRAINT cnstrname
- The constraint name of the relationship used to
join the current table to the owner table.
- PARENT {Y|N}
- Indicates if the current table is the PARENT or
CHILD in the relationship with the owner table.
- Y
- Current table
is the PARENT.
- N
- Owner table is the PARENT.