SQL Remote User's Guide
SQL Remote Design for Adaptive Server Enterprise
Ensuring unique primary keys
To test the primary key pool
Re-extract a remote database using the field_user user ID.
Try this sample INSERT at the remote and consolidated sites:
EXEC NewCustomer 'Great White North', rep1