OE10.2BSP07 Windows 64bit.
OK, so by what magic is the CLOB-Type set within the .df file?
Here's my .df file
Now, in Database A the clob-type is 2, in database B this is set to 1.
Iv'e done incremental's and that doesn't update, I've deleted the table and loaded in with a value of 1 but in Database A it just defaults to 2.
I'm guessing it's down to a setting somewhere as it wont update through the DD.
Any Ideas?
OK, so by what magic is the CLOB-Type set within the .df file?
Here's my .df file
Code:
ADD FIELD "cField" OF "CTable" AS clob
FORMAT "x(8)"
INITIAL ?
POSITION 3
LOB-AREA "Data Area"
LOB-BYTES 104857600
LOB-SIZE 100M
CLOB-CODEPAGE "1252"
CLOB-COLLATION "basic"
CLOB-TYPE 2
ORDER 20
Now, in Database A the clob-type is 2, in database B this is set to 1.
Iv'e done incremental's and that doesn't update, I've deleted the table and loaded in with a value of 1 but in Database A it just defaults to 2.
I'm guessing it's down to a setting somewhere as it wont update through the DD.
Any Ideas?