Kbase 19467: Oracle DataServer: View field length in SH
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2000 |
|
Summary:
The Progress Data Dictionary shows the field's FORMAT size not
the field's STORAGE size.
This can cause confusion for customers when they change the
size of a field in Oracle, update the schema holder and then
look in the data dictionary to verify the change. The length
shown in the dictionary is the FORMAT length.
Details:
When a field's length is altered in the Oracle database, the DataServer -> ORACLE -> Update/Add Table Definition utility
can be used to update the schema holder. After the Update/Add
Table Definition utility has completed, the following code can
be executed to view the schema holder field length.
for each _file where file-name = '<tablename>'.
display _file-name.
find _field of _file where _field-name = '<field-name>'.
display _fld-misc1[3]