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 to use custom messages.

1. Modify the RAPStore and RAPCache database schemas:
   1. In PowerDesigner, modify both the RAPStore and RAPCache physical data models (PDMs) and generate new data definition language (DDL) scripts.
   2. Run the scripts to update the database. See Data Model and Queries > DDL Script Generation.
2. Update RDS message templates:
   1. Locate an RDS message file connected to the table you are adding the column to, and add a field definition block to the file.
   2. If you update message definitions in the RAP Messages model, export them to a message_name.xml template file.
   3. Ensure that all publishers and subscribers are updated with the new RDS message templates by copying the templates into all subscribers.
3. Add a new call to the Publisher API:
   1. Make a new Publisher API call to the appropriate pub_set<type>Field method, based on the datatype of the field.
   2. For fields that can be null, test for null and call pub_setNullField.
4. To apply the changes, stop, shut down, and restart subscribers and publishers.