Edit Definition

The following syntax is used to generate a statement for each exported Edit Definition.

CREATE ED identifier.name 
   [DESC //description//] 
   DEFQUAL defaultqualifier 
   START starttable 
   {AD adname | LOCALAD (addef)}
   MODE {E|B|O} SIDEVIEW {Y|N} DISPLAY_ATTRS {Y|N} 
   DISPLAY_DELETED {Y|N} WARN_DELETE {Y|N} 
   DISPLAY_ROWS nn  UNDOLEVELS nn, 
   VAR_PROMPT {Y|N} {VAR (name, value)…}
   RETAIN_SELCRIT {Y|N}
   TABLE (tablename MODE {E|B|O} SIDEVIEW {Y|N} 
      DISPLAY_ATTRS {Y|N} DISPLAY_DELETED {Y|N} 
      WARN_DELETE {Y|N} DISPLAY_ROWS nn  
      [COL_ORDER //…//] [COL_WIDTHS //…//] 
      [COL_VISIBLE //…//] [COL_LOCKED //…//] 
      [SIDE_COL_ORDER //…//] [SIDE_COL_WIDTHS //…//] 
      [SIDE_COL_VISIBLE //…//] [SIDE_COL_LOCKED //…//]
      [OWNER [[dba.] cid.] tablename TBLID n 
      CONSTRAINT cnstrname       PARENT {Y|N}])
   TABLE (…);

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.