Kbase P104058: Are SQL-WIDTH changes maintained during a dump and load process?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
GOAL:
Are SQL-WIDTH changes maintained during a dump and load process?
GOAL:
When dumping and loading, is the SQL-WIDTH maintained?
FIX:
Yes. Changes to a field's SQL-WIDTH are maintained when the table is dumped.
When the SQL-WIDTH is changed for a field in the database, this change is recorded and will be in all subsequent data definition files that are dumped for that table.
Example:
The customer table in our sports2000 database has a Name field. This field by default has a SQL-WIDTH of 60. This is 2 times the size of the 4GL width for this field. If I were to change the Name field to have a SQL-WIDTH of 75 and then dumped the definitions for the customer table, the Name field will have a SQL-WIDTH of 75. Please see below.
ADD FIELD "Name" OF "Customer" AS character
FORMAT "x(30)"
INITIAL ""
LABEL "Name"
POSITION 3
SQL-WIDTH 75
HELP "Please enter a name."
ORDER 30