Chapter 12. Development Considerations

  • SQL Procedure Language

  • Extenders

  • DB2 ODBC

  • JDBC and SQLJ

  • Stored Procedure Builder

There are many features of the DB2 development environment that offer the use of open standards and the newer languages. We will take a look at the SQL Procedure Language for developing stored procedures. We will also examine the Stored Procedure Builder Tool that can be used for implementing stored procedures built with the SQL Procedure Language and also Java. In the area of extended data types and objects, we will discuss the large object extenders for distinct data types such as video, text, and XML.

For the dynamic and portable world, we will look at dynamic SQL programming with the DB2 ODBC interface, as well as the JDBC ...

Get DB2® Universal Database for OS/390® Version 7.1 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.