SQL use with other host systems

SQL statement syntax exhibits minor variations among different types of host systems (DB2® for z/OS®, DB2 for System i®, DB2 Database for Linux, UNIX, and Windows).

Regardless of whether the SQL statements in an application are static or dynamic, it is important - if the application is meant to access different database host systems - to ensure that the SQL statements and precompile/bind options are supported on the database systems that the application will access.

Further information about SQL statements used in other host systems can be found in the DB2 for System i SQL Reference and the DB2 for z/OS SQL Reference.