Utilities

RDB Connect

Finally, a product that provides easy and full SQL access to remote databases from all System i high-level languages - RDB Connect. Easily access all your databases from an RPG program! The technology used in DBU RDB is now available for programmers to integrate into their applications and tie in remote data to their systems.

RDB Connect is a collection of commands and functions allowing record level access to remote data using RPG, COBOL or CL!  Currently RDB Connect allows access to MySQL, Mircrosoft SQL Server, Oracle, Postgre, Access, DB2 and more. RDB Connect will run on System i with an operating system version of V4R5M0 and above.  It requires an IP connection to the remote server that is running the database to access.

RDB Connect is a stand alone product that offers a procedural API for using SQL queries to access remote data. An implementation of RDB Connect will contain one or more applications, a core RDB Connect library, and one or more "database drivers". The core library, independent of the applications and remote database, acts as an "interpreter" between the applications and the database drivers, whereas the database drivers contain the remote database-specific details. Thus a programmer can write applications that use standard types and features without concern for the specifics of each remote database that the applications may encounter. Likewise, database driver implementors need only know how to attach to the core library. This makes RDB Connect modular.

Click here for more Info ....