Kbase P128368: How can I modify a column's SQL-WIDTH without using the Data-Dictionary tool?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/2009 |
|
Status: Verified
GOAL:
How can I modify a column's SQL-WIDTH without using the Data-Dictionary tool?
GOAL:
How to change a column's SQL-WIDTH without using Dbtool?
GOAL:
How to change a column's SQL-WIDTH using a SQL statement?
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
FIX:
Connect to the database using a SQL-92 client as a user having DBA privileges.
Execute the following SQL statement:
ALTER TABLE <table name> ALTER COLUMN <column name> SET PRO_SQL_WIDTH <value>;
At the moment this method can only be used for CHARACTER and BINARY fields/data types. If the SQL-WIDTH of DECIMAL fields needs to be adjusted the dbtool utility can be used.
Alternatively the Data-Dictionary tool can be used to change the SQL-WIDTH property of individual fields, including fields of DECIMAL data-type.