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.
