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. ...
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.
