(B)0[mmove-relations-clause =
qwqq> [4mMOVE[m [4mRELATIONS[m [4mALL[m qqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqq>
x x
mqwqq> [4mMOVE[m [4mRELATION[m qqwqqqqqqqqqqqqqqqwqq> rse qqqqqqk x
x mq> /* text */ qj x x
x lqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqj x
x mq> [4mSELECT[m [4mFIELDS[m qwqq> [4mALL[m qqqqqqqq>qqqqqqqwqqwqqj
x mwq> select-field-name qwj x
x mqqqqqqqq , <qqqqqqqqqqj x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq ; <qqqqqqqqqqqqqqqqqqqj
Selects the records Replication Option transfers to the target
database during an extraction or a replication transfer. The
records selected for replications are specified with a restricted
form of a record selection expression (RSE). You must specify a
move-relations-clause for each user relation moved to the target
database. If you do not include a move-relations-clause, Replication
Option assumes the default, MOVE RELATIONS ALL.
When you specify a view in a MOVE RELATION clause, the records
selected by that view are created as a relation in the target
database. You can also transfer views using the move-views-
clause.
You must have READ privilege for the relations of an Oracle Rdb
source database that you specify in a MOVE RELATION clause or
a MOVE RELATIONS ALL clause. For databases accessed through the
Rdb Transparent Gateways, Replication Option does not check for
READ privilege for views.
1 – MOVE_RELATIONS_ALL
Allows you to have Replication Option select all records and
fields from all user relations, excluding views, that are in
the source database at the time the transfer is defined. If
you wish to move views, you must use the move-views-clause or
the MOVE RELATION clause. Fields defined with a COMPUTED_BY
clause are restricted to those that use the value expressions
shown in the value-expr syntax diagram in this section. If a
field is not defined by a supported value expression, you will
receive a warning message, and the COMPUTED_BY fields will not be
transferred.
If you define a transfer on a source database that is itself a
target extraction database, do not use the MOVE RELATIONS ALL
clause. An error will result during transfer execution because
Replication Option will attempt to define the DDAL$VINTAGE
relation in the new target database twice. The second transfer
would create a DDAL$VINTAGE relation in the target database.
Then, using the MOVE RELATIONS ALL clause, it would attempt to
copy the DDAL$VINTAGE relation that already exists in the source
database. To avoid this error, specify explicitly each relation
to be moved instead of using MOVE RELATIONS ALL.
Do not use the MOVE RELATIONS ALL statement for an extraction
rollup transfer. If you use the MOVE RELATIONS ALL statement to
define an extraction rollup transfer, the transfer will fail on
execution. Instead, you must name the individual relations you
want to transfer to the extraction rollup target.
2 – text
A text string that allows you to associate a comment with the
transfer definition. The text string, together with other parts
of the transfer definition, appears in the SHOW DEFINITION
display. The DESCRIPTION IS clause is optional.
3 – rse
The record selection expression (RSE) used to identify records
from the source database that Replication Option includes in
a record stream and transfers to the target database. The RSE
specifies conditions that individual records must satisfy in
order to be included in the transfer to the target database.
Replication Option supports COMPUTED_BY fields named in an RSE
if the fields are defined using the value expressions shown in
the value-expr syntax diagram in this section. If the fields are
not defined by a supported value expression, you will receive a
fatal error message.
In extraction, extraction rollup, and replication transfers,
you can use a relation-clause and with-clause. In extraction and
extraction rollup transfers, you can also use a first-clause,
reduce-clause, and sort-clause.
4 – SELECT_FIELDS_ALL
Enables you to include every field in a specific relation. Fields
defined with a COMPUTED_BY clause are restricted to those that
use the value expressions shown in the value-expr syntax diagram
in this section. If a field is not defined by a supported value
expression, you will receive a warning message, and the COMPUTED_
BY fields will not be transferred. You cannot use the SELECT
FIELDS ALL statement for an extraction rollup transfer.
5 – select-field-name
(B)0[mselect-field-name =
qqqqqqqq> context-variable qq> . qqq> field-name qqqqq>
Allows you to name a specific field or group of fields you want
moved to the target database. You can specify only one SELECT
clause for each MOVE clause. Replication Option moves only the
named fields to the target database. If you do not specify SELECT
FIELDS ALL, the select-field-name clause is required.
Replication Option supports COMPUTED_BY fields named in the
select-field-name clause if the fields are defined using the
value expressions shown in the value-expr syntax diagram in
this section. If the fields are not defined by a supported value
expression, you will receive a fatal error message.