Embedded Dynamic Versus Call-Level Interface
Traditional DB2 access facilities like CAF, DSN (TSO), IMS, and CICS use embedded SQL in application programs. This embedded SQL is usually static, but may contain dynamic statements. Dynamic SQL is executed using the PREPARE, EXECUTE and EXECUTE IMMEDIATE statements. Like static statements, these dynamic statements require precompilation and binding to the database to form a package or plan. More information about embedded dynamic SQL is available in Chapter 6, “Binding an Application Program.”
DB2 ODBC data access is always dynamic and does not require precompilation or binding for the application program. This facilitates the migration of programs across platforms, because they execute the same ...
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
