Adding a New Column

Add a new column to a table in 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 column:

  1. Modify the schemas of the RAPStore and RAPCache databases:
    1. Modify both the RAPStore and RAPCashe PowerDesigner models (PDM) and generate new data definition language (DDL) scripts.
    2. Use the scripts to update the database.
  2. Update RDS Message Templates:
    1. Locate an RDS message file connected to the table you are adding the comun to, and add a field definition block to the file.
    2. Ensure that all publishers and subscribers are updated with the new RDS message template(s) by copying them into all subscribers.
  3. Add a new call to the Publisher API:
    1. Make a new Publisher API call to the appropriate pub_setField API, based on the data type of the field. See pub_setField in the Developers Guide.
  4. Restart the subscribers and publishers:
    1. Stop, shut down, and restart the subscribers and publishers to apply the changes.
Parent topic: Customize and Configure the System

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