What's New

Heterogeneous Distributed Query

DB2 Universal Database and DB2 Connect users now have the power of distributed query across any DB2 family database or OLE DB source. This means that users and applications can use the DB2 Universal Database SQL syntax and APIs to access data that resides at heterogeneous data sources. With this functionality, users and applications have the capability of referencing multiple data sources in a single SQL statement. With DB2 Relational Connect, distributed queries can also include Oracle and, with DB2 Version 7.2, Sybase or Microsoft SQL Server databases (see DB2 Relational Connect).

This is the first phase of the integration of DB2 DataJoiner into DB2 Universal Database. DataJoiner is IBM's middleware product for integrating heterogeneous data sources. See the Administration Guide: Planning and the Administration Guide: Implementation for more information.

Access to New Database Management Systems

DB2 Relational Connect Version 7.2 adds data access to these database management systems:

Access to Oracle databases from DB2 on AIX and Windows NT continues to be supported.

With this new support, a single distributed query can now access data in any DB2 family database or OLE DB source, as well as any Oracle, Sybase, and Microsoft SQL Server for Windows NT database.

New Support for Accessing Heterogeneous Data from SQL Procedures

DB2 Version 7.2 allows you to query tables in heterogeneous databases from stored procedures. With Version 7.2, SQL procedures can use nicknames. You can define a nickname for a table in a heterogeneous database, and use that nickname in an SQL procedure.


[ Top of Page | Previous Page | Next Page ]