O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Static Embedded SQL

This section describes how to develop static embedded SQL (which from now on is referred to as "static SQL") applications, including several fundamental concepts of embedded SQL, such as how to connect to databases, how to retrieve data, and how to handle errors.

All embedded SQL programs consist of special source files. These source files can contain standard native programming language syntax, but they also can contain special embedded SQL syntax that can only be understood by a DB2 precompiler. When a source file is precompiled, all embedded SQL specific syntax is converted to DB2 library calls using native programming language syntax.

So, how does the DB2 precompiler distinguish embedded SQL syntax? The answer is simple. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required