Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Autonomous Schema Update (-SQLWidthUpdate)
Autonomous Schema Update (-SQLWidthUpdate)
Operating system and syntax
UNIX / Windows
-SQLWidthUpdate ON
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
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.