Open Group, Data Management: Structured Query Language (SQL), Version 2 (The Open Group, 1996). Recommended Readingįor more information about SQL, the following standards are available:ĭatabase Language - SQL with Integrity Enhancement, ANSI, 1989 ANSI X3.135-1989.ĭatabase Language - SQL: ANSI X3H2 and ISO/IEC JTC1/SC21/WG3 9075:1992 (SQL-92). These include the definitions of non-ODBC functions (those functions whose names do not start with "SQL") and most error handling.Īll code examples use ANSI strings and the same database schema, which is shown at the start of Catalog Functions. In addition, whole sections of code have sometimes been omitted for clarity. Because they are written primarily to demonstrate ODBC principles, efficiency has sometimes been set aside in the interest of clarity. The code examples in this guide are designed for illustration purposes only. Italicized words indicate programmatic arguments, information that the user or the application must provide, or word emphasis.īold type indicates that syntax must be typed exactly as shown, including function names.Ī vertical bar separates two mutually exclusive choices in a syntax line.Īn ellipsis indicates that arguments can be repeated several times.Ī column of three dots indicates continuation of previous lines of code. The monospace font is used for sample command lines and program code.
Uppercase letters indicate SQL statements, macro names, and terms used at the operating-system command level. The following typographic conventions are used.
General DBMS knowledge and a familiarity with SQL. This documentation assumes the following:Ī working knowledge of the C programming language. Use of the ODBC interface spans three areas: SQL statements, ODBC function calls, and C programming. The ODBC interface is designed for use with the C programming language. ODBC Appendixes contain technical details and reference tables for ODBC error codes, data types, and SQL grammar. Installing and Configuring ODBC Software provides information about installation and a setup DLL function reference.ĭeveloping an ODBC Driver contains information on writing a driver.ĪPI Reference contains syntax and semantic information for all ODBC functions. Introduction to ODBC provides a brief history of Structured Query Language and ODBC, and conceptual information about the ODBC interface.ĭeveloping Applications contains information about developing applications that use the ODBC interface and drivers that implement it.
Sample ODBC Program presents a sample ODBC program. What's New in ODBC 3.8 lists the new ODBC features that were added in the Windows 8 SDK. The ODBC Programmer's Reference contains the following sections.
0 kommentar(er)
