Supporting INSERTS at
remotedatabases ForINSERT statements at a remote database to replicate correctly to the
consolidateddatabase, you can exclude from an article only columns that
canbe left out of a valid INSERT statement. These are:
♦Columnsthat allow NULL.
♦Columnsthat have defaults.
Ifyou exclude any column that does not satisfy one of these requirements,
INSERTstatements carried out at a remote database will fail when
replicatedto the consolidated database.
Consolidated ID Rep
Ann
2
1
Marc
Remote ID Rep
2
1 Ann
Marc
Dept
101
101
3 Shih
3 Shih X
INSERT
INTO SalesRep (ID, Rep)
VALUES (3, 'Shih' )
INSERT
INTO SalesRep (ID, Rep)
VALUES (3, 'Shih' )
Insert fails
Insert
succeeds
Conditionson rows Thereare two ways of including only some of the rows in a publication:
♦WHEREclause Youcan use a WHERE clause to include a subset of
rowsin an article. Allsubscribers to the publication containing this
articlereceive the rows that satisfy the WHERE clause.
InSQL Remote for Adaptive Server Enterprise, the only supported
WHEREclause is
WHERE column-name IS NOT NULL
♦Subscriptioncolumns Youcan use a subscription column to include a
differentset of rows in different subscriptions to publications containing
thearticle.
☞Formore information on restrictions on rows, see “Creating articles
containingsome of the rows in a table” on page 144.
148