DB2 Connect™ forwards SQL statements submitted by application programs to IBM mainframe database servers.
Two types of embedded SQL processing exist: static SQL and dynamic SQL. Static SQL minimizes the time required to execute an SQL statement by processing in advance. Dynamic SQL is processed when the SQL statement is submitted to the IBM mainframe database server. Dynamic SQL is more flexible, but potentially slower. The decision to use static or dynamic SQL is made by the application programmer. Both types are supported by DB2 Connect.
Different IBM mainframe database servers implement SQL differently. DB2 Connect fully supports the common IBM® SQL, as well as the DB2 for z/OS®, DB2 Server for VM and VSE (formerly SQL/DS), and IBM DB2 for IBM i implementations of SQL. IBM SQL is strongly recommended for maintaining database independence.