Objectives

You should already understand a supported native/host programming language for embedded SQL prior to reading this chapter. The supported languages are C, COBOL, REXX, FORTRAN, and Java. In Java, embedded SQL is implemented using the SQLj specification discussed in Chapter 12 “Java Programming.” We should note here that although similar principles are followed when developing SQLj applications, it will help you greatly if you understand this chapter and one of the other three supported embedded SQL programming languages.

By the end of this chapter, you will understand the following:

• How to develop static embedded SQL applications.

• How to develop dynamic embedded SQL applications.

• The important differences between static and dynamic embedded SQL.

• When to use dynamic SQL and when to use static SQL.

• How to precompile and bind embedded SQL applications.

• The important steps that occur during precompilation and binding.

Most of the sample code in this chapter is shown either in C or in pseudocode.