Download to view the file - Support On Line

SQL7 Administrator's Guide
RMGEN does not solve these problems automatically. However, the TRANSLATE
command is normally aborted and the execution report shows where the problems are.
The Administrator must then re-submit the TRANSLATE command, specifying ALIAS
directives. RMGEN does not apply any modification to the ALIAS names (these names
appear in the execution report). Several runs with different sets of ALIAS directives may
be required to have all the conflicts solved and a model finally generated.
NOTE:
Only the DDL name of a not SUPPRESSed object (i.e. an object of the Rschema) can be ALIASed.
To summarize, the Administrator:
• may use the ALIAS directives to choose names of his/her own,
• must use the ALIAS directives to solve name syntax problems and name conflicts.
6.2.4
Model Derivation Basic Rules
Overview
The following relational objects are derived for each record-type X of the R-schema (i.e.,
the initial schema possibly reduced through SUPPRESS directives):
• a table whose name Y is:
- either derived from X by RMGEN,
- or specified through an ALIAS directive,
any given tuple of the Y table is built with the data from a given IDS/II record
occurrence of type X. Therefore each tuple is associated with an IDS/II emitting
record,
• for each elementary data item of X, a column of the Y table, with its name:
- either derived by RMGEN from the DDL name of the originating field,
- or specified through an ALIAS directive.
DDL fields not bearing information (structuring groups) are ignored
Also refer to the Field paragraph for special cases (Occurs attribute)
• a column of the Y table, with name:
- either TUPLE_ID,
- or its Alias specified through an ALIAS NAME directive.
This column represents the emitting record database key (see the paragraph on
'Field' for the dbkey external representation.
The SQL processor considers this column as a unique order and access key (a
kind of primary key), and uses it accordingly for request execution optimization.
This column can be optionally omitted (through a SUPPRESS directive), except if a
set with record-type X as owner has to be represented in the model.
6-6
47 A2 51UR Rev02