Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : Autonomous Schema Update (-SQLWidthUpdate)
 

Autonomous Schema Update (-SQLWidthUpdate)

Use the Autonomus Schema Update (-SQLWidthUpdate) 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.
Operating system and syntax
UNIX / Windows
-SQLWidthUpdate ON
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
DBS
OFF
OFF
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.