Contents Index Adding new customers Primary key pool summary

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Ensuring unique primary keys

Testing the key pool


To test the primary key pool

  1. Re-extract a remote database using the field_user user ID.

  2. Try this sample INSERT at the remote and consolidated sites:

    EXEC NewCustomer 'Great White North', rep1

Contents Index Adding new customers Primary key pool summary