During bulk loading operations such as DataSync syncs, Replication initial states or Insert-Select SQL statements string data is truncated to fit into the target columns.  This is done so that the entire operation doesn't stop because one string did not fit into the target, it is just truncated to the correct size and inserted.  This setting will cause an error when truncation occurs during one of these bulk loading operations.  The error will stop the entire operation from proceeding if any data must be truncated to fit into the target.

 

ERRORONTRUNCATE = 1 

 

Default = 0.

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  ERRORONTRUNCATE

 

Unix Registry Setting: CONNX.ERRORONTRUNCATE