Database Packages and Query Performance
To understand how all applications communicate with DB2, a short discussion of how packages are bound in embedded SQL is necessary. The popularity of embedded SQL on Intel and UNIX platforms has decreased with the emergence of more portable programming interfaces. However, embedded SQL in COBOL is the prevalent database programming method for host systems such as DB2/390, and there are still many legacy applications on common server platforms as well. In addition, embedded SQL forms the foundation for DB2 UDB programming since even driver-based interfaces use embedded SQL source modules at the base level.
The reason for this is best understood by returning to the discussion about database objects known ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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.
