Question Clob-type

BigSlick

Member
OE10.2BSP07 Windows 64bit.

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?
 

BigSlick

Member
Thanks Cringer. The post was helpful.

Although, it raised a few questions;
Can i update the _Attributes1 field manually?
Where do code page and collation get set?

If code page and collation only get set within OE explorer both databases had the same values. Hence why i ask a rather simple question.

Yes. I agree. It's something i will look at after the OE11 upgrade.
 

TomBascom

Curmudgeon
There are a number of -cp* startup parameters. Global default values can be found in $DLC/startup.pf. The contents are the result of options that were selected when Progress was installed.) You can over-ride those defaults with your own .pf file or on scripted command lines or in .INI files or in conmgr.properties if you have the misfortune to be stuck with a "managed" database.

You should not attempt to directly fiddle meta-schema fields -- it's a good way to really foul things up. Reading them is ok. Updating them is playing with fire. In a very dry forest.

Frankly I wouldn't touch OE Explorer with a 3 meter pole... nothing good ever comes from letting mice run around.
 
Top