RMSPaddedNoNulls controls whether CONNX treats a field filled with binary zeros as either NULL, or as an empty string, when converted to SQL.  The default behavior is to read a field with all binary zeros as SQL NULL.  To change this behavior, set the variable to 1.

 

RMSPADDEDNONULLS = 1

 

Default = 0 (binary zeros are treated as a SQL NULL).

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX\RMS; Key Value/Value Name =  RMSPaddedNoNulls

Unix Registry Setting:  CONNX.RMS.RMSPADDEDNONULLS