ADA_FIELDNULLASZERO = 1

 

Enables Alpha fields filled with binary 0's, to be treated as a SQL Null field. Natural programs sometimes will fill alpha fields with binary 0's if they are unused. If the table is to be replicated with Open Systems Event Replicator, or using SQL ("insert/select"), this will cause binary 0 filled text fields to be converted to a space padded null text fields for the target table. This potentially means that records might not be available using a superdescriptor, if there was a case where a zero filled field turned into a space padded field. This is due to Adabas not being able to access a record if any of the superdescriptor fields are blank. Therefore For Replication customers, it is advised to set this field to 0.

 

Default = 1.

 

Environments: Client, Server, Windows, Mainframe, Unix, Adabas

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