Select which standards option you want for the generated SQL. The option that you choose will affect the syntax of the generated SQL and ultimately how the generate SQL will run. You may edit this value.
You may choose.
ANSI/ISO
DB2 family
DB2 with extensions
The DB2 family supports SQL syntax that is not supported by the ANSI/ISO standard. Furthermore, the products in the DB2 family support SQL that is not supported on this system and i5/OS supports SQL that is not yet available on other DB2 products.
As a general guideline, if you want to generate SQL that will be run on other DB2 platforms, select DB2. Additionally, if the platform is another system running i5/OS, select to include Extensions. If you want to generate SQL that can be executed on other ANSI/ISO SQL standard compliant databases, select ANSI/ISO.
The choice that you make for the standard can affect the choices that you make for formatting. For more information, see Formats supported by the standards.
The default is DB2 with extensions.