If set, this will honor the length of a field that is an ADABAS W Field. If the W field is defined to be 8 Bytes, then CONNX will register it as 8 bytes. The default is to multiply W fields by 2 to allow for more potential storage in the case they represent languages that use 2 or more bytes per character (example Chinese). This is invoked when CREATE TABLE DESCRIPTION or CREATE TABLE is done using NCHAR fields. An example would be:


CREATE TABLE DESCRIPTION L7000   DATABASE NUMBER 2 FILE NUMBER 55                                               

(                                                                            

    ADA_ISN                          SEQNO(0)  NOT NULL,                                                         

    AA nchar (8) SHORTNAME 'AA'

);     

 

In this example, AA would be represented as 8 Bytes in the CONNX CDD if ADA_WFIELDASBYTES is set to 1, or it will be 16 bytes (Default) if the Setting is not set, or is set to 0.

 

To invoke set registry in the ADABAS section to:

ADA_WFIELDASBYTES = 1

 

If ADA_WFIELDASBYTES = 0, CONNX will represent the column size for W fields by  multiplying  the  FDT column size by 2. (Default)

If ADA_WFIELDASBYTES = 1, CONNX will represent the column size for W fields by using the actual FDT column size.

 

Default = 0.

 

Environments: Client,  Windows,Unix, Adabas

Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name =  ADA_WFIELDASBYTES