IBM i Advantages Hardware resources Virtualization Software Support and services Resources News Related links IBM Power Systems Redbooks PartnerWorld

IBM Power Systems software  >  IBM i  > Software  >  System i Access     Overview Windows Linux Web Wireless System i Access for Windows    |   Service Packs    |   Downloads    |   Documentation    |   Support    |   Functions   Operations Console   Data Access Components   ODBC   .NET Data Provider   Ordering and Installing Languages   PC5250   OLE DB Support   XDA     ODBC Driver What is the ODBC Driver ? The System i Access for Windows ODBC driver provides SQL access to System i database files, using standard ODBC interfaces. Applications developed according to the ODBC specification can be used to access data from any database management system (DBMS) which provides an ODBC driver. This eliminates the need to code to multiple proprietary database interfaces. The System i Access for Windows ODBC driver conforms to the Microsoft ODBC 3.5 specification. Refer to the following resources for details: Microsoft Open Database Connectivity (ODBC) System i Access for Windows Database sample programs (See ODBC section) System i Access -> Programming -> iSeries Access for Windows: Database programming ->iSeries Access ODBC What's new? These are the enhancements that were added to the ODBC driver in V6R1 release: SQL query storage limits ODBC application and QZDASOINIT system jobs association 128-byte cursor names Decimal Floating Point (DECFLOAT) data type Improved support for default values (Extended Indicator support) Enables an application to specify the colu