IBM Data Server Client support for database application development

The Data Server Client includes the following features:

• Precompilers for C/C++, COBOL, and Fortran, (providing the language is supported for that platform).
• Embedded SQL application support, including programming libraries, include files and code samples.
• ODBC and DB2® Call Level Interface (DB2 CLI) application support, including programming libraries, include files, and code samples for developing applications which are easily ported to ODBC and compiled with an ODBC SDK. An ODBC SDK is available from Microsoft for Windows operating systems, and from various other vendors for many of the other supported platforms. On Windows operating systems, the ODBC and CLI driver is installed by default with the DB2 Client, supporting applications developed with the Microsoft ODBC Software Developer's Kit. For all other platforms, the ODBC and CLI driver can optionally be installed with the DB2 Client, supporting applications that can be developed with an ODBC SDK for that platform, if one exists.
• The IBM® Data Server Driver for JDBC and SQLJ, which includes:
  • Support for JDBC 3 and JDBC 4 compliant applications
  • SQLJ support, for developing Java™ applications with static SQL
• Java 5 environment is embedded in DB2 servers to support server-side Java application artifacts including stored procedures and user-defined functions
• ActiveX Data Objects (ADO) and Object Linking and Embedding (OLE) automation routines (UDFs and Stored Procedures) on Windows operating systems, including code samples implemented in Microsoft Visual Basic and Microsoft Visual C++.
• Object Linking and Embedding Database (OLE DB) table functions on Windows operating systems.
• C# and Visual Basic .NET applications and CLR .NET routines on Windows operating systems.
• Ruby and Ruby on Rails application support , including IBM_DB gem for easy install and code samples. Ruby is a fully-integrated object-oriented programming language used to develop web applications. Ruby on Rails (RoR), also known as Rails, is a framework for developing web applications that access databases according to the Model-View-Control architectural framework
• PHP Hypertext Preprocessor application support , including programming libraries and code samples. PHP is a scripting language used to develop web applications. It also supports object-oriented programming
• IBM Data Studio is a comprehensive suite of integrated Eclipse tools for the database developer and development DBA. IBM Data Studio reduces the time to perform day-to-day administration tasks, create, deploy, and debug SQL and Java stored procedures, deploy data-centric web services, and create queries for relational and XML data using SQL and XQuery for DB2 and Informix® data servers.
• Interactive SQL through the Command Line Processor (CLP) to prototype SQL statements or to perform ad hoc queries against the database.
• A set of documented APIs for other application development tools to implement precompiler support for DB2 directly within their products. For example, IBM COBOL on AIX® uses this interface.