Autonomous schema update

Autonomous Schema Update (ASU) helps resolve the SQL width problem by updating the SQL column width in schema automatically when data exists in columns which are more than their defined width. When an SQL query is executed, with ASU enabled, truncated data is returned, and the column width is adjusted to accommodate the complete data. Consequent execution of the query returns the full data without any truncation. The ASU feature is off by default and the user has to enable this feature while starting database. To enable the feature, a server startup parameter -SQLWidthUpdate is added. This parameter takes the values as ON and OFF. The default value is OFF. Once the value of the parameter is set, it is remembered for the lifetime of the server and for all connections. If the value of the -SQLWidthUpdate parameter is set to ON during startup, the Authorized Data Truncation (ADT) feature is also enabled and defaults to OUTPUT irrespective of whether ADT was enabled during startup unless specified otherwise using connection URL. If for a specific connection, the ADT feature is disabled using connection URL or ODBC driver option and the ASU feature is enabled during startup, the ADT feature remains turned off for that specific connection.