Operating system and syntax UNIX / Windows
-SQLWidthUpdate ON
Use with Maximum value Minimum value Single-user default Multi-user default
DBS OFF OFF
ON

Set the value of this parameter as ON, during startup, to resolve the SQL width problem by updating the SQL column width in schema automatically when Authorized Data Truncation(ADT) occurs for data in a column. Once the value of the parameter is set, it is remembered for the lifetime of the server and for all connections. If this parameter is set to ON during startup, the Authorized Data Truncation(_SQLTruncateTooLarge) parameter is also enabled irrespective of whether ADT was enabled during startup unless specified otherwise using connection URL.

The Autonomus Schema Update (-SQLWidthUpdate) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.