Chapter 11. ODBCCLI Programming | DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)

092 - Chapter 11. ODBC/CLI Programming <ul><li> <p clas><script> function OpenWin(url, w, h) { if(!w) w = 400; if(!h) h = 300; window.open(url, "_new", "width=" + w + ",height=" + h + ",menubar=no,toobar=no,scrollbars=yes", true); } function Print() { window.focus(); if(window.print) { window.print(); window.setTimeout('window.close();',5000); } } </script><span></span></p> <table width="100%" cellpadding="0" cellspacing="0" border="0"><tr valign="top"></tr></table> <table width="100%" height="20" border="0" cellpadding="0" cellspacing="1"><tr></tr></table> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td align="center"><table width="95%"><tr><td align="left"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size="1" color ="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td valign="top" width="76" rowspan="4"><img src="/books/2/607/1/html/2/images/0131007718/0131007718_xs.jpg" width="76" height="95" border="0"></td> <td valign="top">DB2 Universal Database for OS/390 v7.1 Application Certification Guide<br>By Susan Lawson<br> </td> </tr> <tr><td>Table of Contents</td></tr> <tr><td></td></tr> <tr><td valign="bottom">Part 4. Programming and Language Environments</td></tr> </table> <hr size ="1"> <br><table width="100%" border="0" cellspacing="0" cellpadding ="0"><tr><td valign="top"> <h2>Chapter 11. ODBC/CLI Programming</h2> <ul> <li><p>Embedded Dynamic SQL Versus Call-Level Interface</p></li> <li><p>The DB2 ODBC Environment</p></li> <li><p>Handles</p></li> <li><p>Database Connections</p></li> <li><p>Transaction Control</p></li> <li><p>Executing SQL Statements</p></li> <li><p>Retrieving Results</p></li> <li><p>ODBC Stored Procedures</p></li> <li><p>Error Handling and Problem Determination</p></li> <li><p>Sample Program</p></li> </ul> <p>DB2 Open Database Connectivity (ODBC) is IBM's callable SQL interface for the DB2 family of products. It is a C and C++ application programming interface (API) for relational database access, and it uses function calls to pass dynamic SQL statements as function arguments. Other languages can use the ODBC API, but it is usually defined using the C language.</p> <p>ODBC is an alternative to embedded dynamic SQL, but unlike embedded SQL, it does not require that a program be precompiled. DB2 ODBC is based on the Microsoft ODBC specification and the X/ Open Call-Level Interface (CLI) specification. These specifications were chosen as the basis for the DB2 ODBC in an effort to follow industry standards and to provide a shorter learning curve for those application programmers already familiar with either of these <span>data source</span> interfaces. In addition, some DB2-specific extensions were added to help the DB2 application programmer specifically exploit DB2 features. DB2 ODBC is derived from the ISO Call-Level Interface Draft International Standard (ISO CLI DIS) and ODBC Versions 2.0 and 3.0. DB2 provides both ODBC and CLI drivers.</p> <p>DB2 ODBC programs can execute on many different platforms. This chapter deals with programs that run on OS/390 and z/OS systems. Programs executing on other platforms follow the same coding conventions, but details of the interface may vary, and the corresponding DB2 Universal Database references should be reviewed.</p> </td></tr></table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size="1" color="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" align="right">Top</td></tr></table> </td></tr></table></td></tr></table> </li></ul>