Version 5
|
|
Version 5
|
The DB2 Call Level Interface (DB2 CLI) has been updated to the latest Microsoft ODBC 3.0 specifications. This enables ODBC 3.0 applications to run with DB2. Scrollable Cursor support has also been added. See the CLI Guide and Reference for details.
The following support has been added:
See the API Reference for a full description of DB2 APIs. See the Embedded SQL Programming Guide for a description of the precompiler options.
Enhancements have been made for table functions and scalar functions:
Depending on how a UDF needs to process a LOB value, this can result in a great improvement in both performance and in memory utilization.
See the Embedded SQL Programming Guide and the SQL Reference for details.
The precompile and bind enhancements are categorized as follows:
DB2 enables you to develop applications and applets that access and manipulate DB2 databases. DB2 makes this possible by providing support for the Sun Microsystem's Java Database Connectivity (JDBC) API. DB2 provides this support through a DB2 JDBC driver that comes with DB2. The JDBC API provides a standard way to access databases from Java code. Your Java code passes SQL statements as function arguments to the DB2 JDBC driver. The driver handles the JDBC API calls from your Java code.
You can also use the Java programming language to develop user-defined functions and stored procedures which run on the server.
See the Embedded SQL Programming Guide and DB2 Connect documentation for details.
See "Extended Support for Java Applets" and "Support for JDBC and SQLJ" for information on Java support in DB2 Universal Database Version
5.2.
 |
Version 5.2
|
Applications running under Microsoft Transaction Server (MTS) on Windows NT, Windows 95, and Windows 98 operating systems can use MTS to coordinate two-phase commit with multiple DB2 Universal Database databases and other MTS-compliant resource managers. See the Administration Guide and "Microsoft Transaction Server" for details.
See the DB2 Connect Enterprise Edition Quick Beginnings manual for information on how host and AS/400 databases can participate in distributed transactions managed by MTS.
MTS support is enabled by setting the tp_mon_name configuration parameter (see the Administration Guide).
The DB2 Java Database Connectivity (JDBC) Applet Server can now be started as a Windows NT service. It must be registered as a service before it is made available in the services section of the control panel. See "JDBC Applet and Application Support" and the Quick Beginnings documentation for details.
DB2 Universal Database provides support for Java Database Connectivity (JDBC) and for Java Embedded SQL (SQLJ).
JDBC support consists of:
See "Programming in JDBC" for details.
SQLJ support allows you to run Java embedded SQL applications and applets on the client against DB2 databases on the server. It also provides support for Java embedded SQL UDFs and stored procedures on the server. See "Embedded SQL for Java (SQLJ) Programming" for details.
The Database Independent Interface for Perl (Perl DBI) is an Application Programming Interface (API) that provides database access for the Perl language. The DBI defines a set of functions, variables, and conventions that provide a consistent database interface independent of the actual database being used. A specific database driver is required to work in conjunction with the DBI in order to access a particular database.
In Version 5.2 of DB2 Universal Database, support for the Perl DBI is provided on the AIX, HP-UX, and Solaris platforms. This support is available with the DBD::DB2 database driver. The driver and documentation can be obtained through FTP and the Web. For more information, see http://www.software.ibm.com/data/db2/perl.