After the statements are stabilized, the stabilized access path can be retrieved and used from  the catalog tables at full prepare when Db2 does not find the statements in the dynamic  statement cache. Db2 can provide consistent performance with a stabilized dynamic SQL  statement. Performance improvement for the dynamic prepare is also possible when the  statements are found in the catalog instead of having to go through a full prepare.  This feature is expected to be useful during workload transitions, configuration changes, and  when applying future Db2 maintenance upgrades. Dynamic statement stability requires the activation of Function Level 500 or greater and  provides various monitoring and statistics changes in prepare operations. The key improvements and features that are delivered by Db2 12 for z/OS in addition to  performance improvements are described in this section. For more information about Db2 12  features, see  IBM DB2 12 for z/OS Technical Overview , SG24-8383. Db2 12 for z/OS also  includes the following other key features: A large set of new SQL capabilities are introduced or enhanced in Db2 12 to encourage the  application development and porting in Db2 for z/OS. Db2 Adaptor for z/OS Connect enablement, introduced in Db2 11, made it faster and easier to  deploy RESTful services that access Db2 data. However, this solution requires the installation  and setup of z/OS Connect services.  To speed up application deployment, native REST support is now built into Db2. With native  REST API support, Db2 DDF address space provides a set of services to replace the Db2  Adaptor and z/OS Connect features. JSON is used to pass input and return the results back  to the requester. Native REST API support is available in Db2 12 and Db2 11 (with APAR  PI66828).  Db2 12 expands SQL capability to continue to support and attract today’s application  development.  Enhancements in application enablement include advanced triggers, which allow developers  to create the logic within a trigger. An enhanced MERGE statement is now aligned with the  behavior that is defined in the SQL standard and Db2 family, and now allows you to delete  from the target tables. Db2 12 provides SQL propagation features that support both numeric  and data dependent pagination. Piece-wise data modification support allows the developer to specify a FETCH FIRST clause  for a DELETE statement and issue a COMMIT. This ability addresses many possible  concerns, such as lock contention, long-running UR, and CF effect or recovery.  18  IBM Db2 12 for z/OS Performance Topics Application enablement  RESTful API 1.3.1 Mobile application enablement 1.3 Other key features in Db2 12 for z/OS GLYPH<SM590000> Mobile application enablement GLYPH<SM590000> Resiliency and continuous availability GLYPH<SM590000> Simplified migration and continuous delivery support 