SQL Remote User's Guide
SQL Remote Design for Adaptive Server Enterprise
Creating publications
You can combine a WHERE clause and a subscription expression in an article.
All columns in the primary key must be included in any article.
You must not include a subset of columns in an article unless either:
The remaining columns have default values or allow NULLs.
No inserts are carried out at remote databases. Updates would not cause problems as long as they do not change primary key values.
If you include a subset of columns in an article in situations other than these, INSERT statements at the consolidated database will fail.