Adding a New Table

Add a new table to your RAPStore and RAPCache database schemas if the standard schemas do not suit your needs, or if you want to use custom messages.

To add a new table:

  1. Modify the RAPStore and RAPCache database schemas:
    1. Generate both the RAPStore and RAPCache PDMs and DDL scripts for the new table.
    2. Use the scripts to update the database. See "Generating DDL Scripts" in chapter 4 of the Users Guide.
  2. Create a new RDS Message Template:
    1. Create a new RDS Message definition specifying the new table as the destination table.
    2. Ensure that the Message Type has a unique value across all RDS Message definitions.
    3. For each column in the new database table, add a field definition block to the Message definition.
    4. Ensure that all publishers and subscribers are updated with the new RDS message templates by copying the new information to all subscibers.
  3. Modify the Publisher Code:
    1. Make a call to the pub_beginMessage API specifying the new message definition's message type.
    2. For each field in the message, make a call to the appropriate pub_setField API in order to pass in the field data.
    3. Make a call to the pub_sendMessage API to send the data. See "Publisher API" in the Developers Guide.
  4. Restart the subscribers and publishers:
    1. Stop, shut down, and restart the subscribers and publishers for the changes to take effect.
Parent topic: Customize and Configure the System

Created April 9, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com