Features to Watch For

This section describes a number of features that application developers often take for granted. In fact, these features vary widely in support and manner of support among DBMSs; failure to code for them is likely to cause problems in interoperable applications.

This section does not list all features that application developers need to consider. For that information, see the SQLGetInfo, SQLSetStmtAttr, and SQLSetConnectAttr function descriptions, Appendix C: SQL Grammar, and the sections of this manual that discuss each feature.

This section contains the following topics.

• Version Number

• Multiple Active Statements and Connections

• Transaction Support in DBMSs

• Commit and Rollback Behavior

• NOT NULL in CREATE TABLE Statements

• Supported Data Types

• ODBC SQL Grammar

• Batch Processing