Kbase P88693: CLOB field information not in delta.df
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2009 |
|
Status: Unverified
SYMPTOM(s):
CLOB field information not in delta.df
LOB-AREA information for CLOB missing in delta.df
LOB-BYTES information for CLOB missing in delta.df
LOB-SIZE information for CLOB missing in delta.df
CLOB-CODEPAGE information for CLOB missing in delta.df
CLOB-COLLATION information for CLOB missing in delta.df
CLOB-TYPE information for CLOB missing in delta.df
FACT(s) (Environment):
OpenEdge 10.x
CAUSE:
Bug# 20040721-014
CAUSE:
Bug# OE00107731
FIX:
Upgrade to OpenEdge Release 10.0B01 or later
FIX:
To add a new CLOB field definition to the incremental delta.df file do the following:
1. Dump the definition of the table using either the Data Admin or Data Dictionary Tool: Admin->Dump Data and Definitions->Dump Definition(.df file)
2. Copy the whole ADD FIELD block of information and add to the delta.df file.
This is an example of what the block of information looks like for a new field in the customer file:
ADD FIELD "Co-mission" OF "Customer" AS clob
FORMAT "x(8)"
INITIAL ?
POSITION 19
LOB-AREA "Customer/Order Area"
LOB-BYTES 104857600
LOB-SIZE 100M
CLOB-CODEPAGE "ISO8859-1"
CLOB-COLLATION "BASIC"
CLOB-TYPE 2
ORDER 35
3. Apply the delta.df to the target database.