OpenEdge SQL offers the following new features in OpenEdge 12.2:

ISO functionality

OpenEdge SQL now supports the ISO WEEK (), DAY () and YEAR () functions for a given input date.

These topics can be found in the OpenEdge SQL Reference.

SQLWidthUpdate

Autonomous Schema Update (ASU) helps resolve the SQL width problem by updating the SQL column width in schema automatically when data exists in columns that are more than their defined width. 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 the connection URL.

For more information, see Autonomous schema update in OpenEdge Data Management: SQL Development.