Schema Customization

Use the WSP Schema Designer to modify the flexible database schema of CA SDM to meet your needs. The Schema Designer provides a graphical user interface to review and modify the CA SDM schema. Web Screen Painter also lets you test your schema changes on your own web forms before updating the physical DBMS schema or affecting other users.

You can make the following types of schema changes to use in your own forms and reports:

Add tables to the database
Add columns to existing tables
Make a column required
Modify a table, column display name, or function group

Consider the following information before using Web Screen Painter:

You cannot use WSP to change the length of an existing column, and we strongly recommend that you do not use other tools to do so. Changes to the length of an existing column are not supported, and may cause other applications accessing the CA SDM database to fail.
Important! Do not shorten a field or delete an existing field, because these actions could cause CA SDM to fail.
Be careful when adding columns to an existing table, because you can inadvertently exceed the record length capacity of the underlying database. Check the specifications for the database that you are using with CA SDM and make modifications within the limits of that database.
Publishing changes to the database schema could require limited or considerable downtime, depending on the changes you make and the capabilities of your underlying database.
If you are a new user of CA SDM, it is easier to make all of your changes during testing instead of waiting until you are in production.
Review general procedures you must complete before and after changing the database schema.
Use specific procedures to customize your schema. Most of these procedures are followed by an example of a change you might want to make to the standard database schema.

Important! Web Screen Painter verifies that the first letter of a new table or column name is “z”, and inserts a “z” if necessary. This verification helps ensure that your user-defined field names do not conflict with field names used by CA SDM, now or in future releases.