SolutionsIQ CONNX to a Host of DB2 Hosts

Ken Deats

SolutionsIQ (Bellevue, Wash.) has announced a new edition of its CONNX data access middleware—CONNX 8.2—which will add support for IBM's recent and current versions of DB2 database on OS/400, Linux, OS/2, Warp Server 4.0, Windows 95/98/NT 4.0, MVS and OS/390.

CONNX functions as a single, master data access engine that gives PC users real-time access to data from multiple enterprise sources without programming or disruption to existing systems. CONNX can present data from multiple databases as one relational database. In addition to support for DB2, CONNX also supports native access to Digital RMS, Digital DBMS, Oracle Rdb, Oracle RDBMS on all platforms, and DataFlex/PowerFlex.

"One of the most complex challenges that businesses face is finding a technology that allows them to leverage their most accurate, up-to-the-minute data so they can make smart, fast decisions and increase their business savvy," says Jon-Jacques Umphrey, product manager for CONNX. "CONNX allows enterprise users secure access to the data they need in real-time, regardless of its origin."

The CONNX 8.2 DB2 Module can transform dynamic SQL statements into precompiled static SQL statements. Over the life of a connection, CONNX collects every SQL statement that has been executed at least once. If a statement is used again, CONNX can recognize and re-execute the statement. As the use of a statement increases, so does its performance and execution speed.

CONNX 8.2 supports OS/400 Command-Line execution from an ODBC client. When connected to an OS/400 target via any ODBC-compliant application and CONNX 8.2 for DB2, authorized users can submit OS/400 commands to the target host. It also supports stored procedure execution across all DB2 platforms. The stored procedures can be implemented in compiled languages such as IBM Assembler, COBOL, FORTRAN, PL/I, and RPG, or in interpreted languages such as Java or OS/400 CL. CONNX 8.2 for DB2 provides full support for stored procedures that return one or more result sets.

CONNX 8.2 implements the X/Open DRDA AR (Distributed Relational Database Access Application Requester) functionality. Supported connectivity options include native TCP/IP via the Winsock API; APPC / LU 6.2 via third-party SNA vendor software, including Attachmate EXTRA!; IBM Communications Server 5.0 and 6.0; Microsoft SNA Server 4.0; Novell NetWare for SAA 4.0; and Wall Data RUMBA.