Kbase P20750: How to manually change column size for both schema holder and ORACLE when a delta df includes change
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/11/2004 |
|
Status: Verified
GOAL:
How to manually change column size for both schema holder and ORACLE when a delta.df includes change of column size?
FACT(s) (Environment):
Oracle DataServer
FIX:
When a delta df contains increase of column size, and Incremental df Progress to Oracle is run, either both the produced delta df for schema holder and delta sql or delta SQL alone for Oracle do not contain any modifications related to these change. This is because the format defines only the display of the field. A format change does not mean the field size changes.
The following steps can be followed to manually achieve the changes to both Schema Holder and Oracle database.
1. Use ALTER TABLE <table-name> to manually change field size in Oracle
2. Re-pull the table definition after you have changed the size of the field over Oracle. Use the option Update/Add Table definitions and select the table that you have changed manually.
Or
1. Use ALTER TABLE <table-name> to manually change field size in Oracle
2. Create a .df file that updates the field you want to change the field size. The syntax would be:
update field "field-name" of "table-name"
field-misc13 <size>
foreign-maximum <size>
Both sizes need to be the same and need to match with the Oracle definition.
For example:
update field "name" of "customer"
field-misc13 35
foreign-maximum 35
3. Load the .df into the schema holder.