• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • ProData Freshens Up Database Access with RDB Connect 4

    December 2, 2014 Alex Woodie

    The days when all the data you needed to access resided in DB2/400 have long since passed, and today, being able to access data on other systems is a fact of life. One vendor helping IBM i shops get the most out of their disparate data sources is ProData Computer Services, which recently updated its remote database access tool, called RDB Connect.

    RDB Connect is a collection of commands and functions that enable RPG, COBOL, and CL programs to have record-level access to data residing on other databases, including Microsoft SQL Server, MS Access, Oracle and MySQL, PostgreSQL, and DB2 for LUW. This allows programmers to focus on the business logic of the application without regard for the specifics of each remote database they want to access.

    With RDB Connect 4.0, ProData has added a new menu-driven interface that should provide quick access to commands. The new RDBConnect Menu includes the following commands: RDBCFG(RDB Configure); RDBJARCFG(JAR Configuration); RDBTABLES(Database Tables); RDBFIELDS(Database Fields); RDBRUNSQL(Run SQL Statement); RDBTRACE(Turn Tracing ON/OFF); RDBIMPORT(Database Import); RDBEXPORT(Database Export); and RDBPTF(PTF Processor).

    Keeping multiple databases in sync is critical in today’s data-driven economy, and now with version 4.0, RDB Connect can be used to push DB2 for i data out to other databases. The introduction of the RDBEXPORT command gives the programmer the option to push all DB2 for i fields to the remote database, or just push specific fields.

    Another new feature is an API called “RDBsetIsoDate” that can be used to transfer ISO Dates from IBM i to the remote database. This prevents errors when transferring to another IBM i machine, the company says.

    RDB Connect is a 5250 program and is used primarily via the keyboard. But with version 4.0, the software recognizes double-clicks of the mouse, enabling programmers to access RDB Connect’s F-keys using either the mouse or the keyboard.

    Version 4 brings several other new features, including better error handling when importing to IBM i to prevent invalid characters on IBM i file columns; new functions to the Manage Remote Systems (RDBCFG) command; a new option column in the RDBTABLES command to display the fields for each table; and the new RDBTRACE capability that warns a user when the log file size has maxed out.

    ProData owner and CEO Allen Hartley says the update gives customers more remote database connectivity. “RDB Connect allows our customers to easily share data across platforms within their programs, which can eliminate data transfers or duplicate data entry in some cases,” he says. “RDB Connect 4.0 makes it even easier with the new interface provided for first-time users.”

    RELATED STORIES

    ProData Updates DBU and Deleted File Retriever

    ProData Widens Database Support with RDB Connect

    ProData’s Remote Database Access Tool Gains Automation



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Maxava

    Migrating to New IBM i Hardware?

    Whether you are moving to POWER9, Power10, or a cloud hosted system MAXAVA HAS YOU COVERED!

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    NGS:  Attend our FREE COMMON Virtual Session on integrated reporting & BI from your desk! Dec 16.
    Profound Logic Software:  Now On-Demand Webinar: "See What i Can Do with Mobile Applications"
    BCD:  Beat Your Q4 Numbers with Real-Time Analytics on IBM i. Watch video!

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    IBM Adds Enterprise Power8 Systems To Trade-In Deal Fuzzy Matching In RPG

    Leave a Reply Cancel reply

Volume 14, Number 23 -- December 2, 2014
THIS ISSUE SPONSORED BY:

New Generation Software
Profound Logic Software
Fresche Legacy
Shield Advanced Solutions
Focal Point Solutions Group

Table of Contents

  • IBM Sets Out to Save Email with ‘Verse’
  • SAP on IBM i Kernel Upgrade Taxes CPU
  • Demand Building for Node.js on IBM i
  • Infor to Drop Support for IBM i 6.1 with ERP Apps
  • A ‘FastPass’ to IBM i Password Satisfaction
  • Ditch the Check Writing, Says VAI
  • A Power Tool for IBM i User Administration
  • IBM i Shops Climb Into the VAULT
  • ProData Freshens Up Database Access with RDB Connect 4
  • Web Dev Tool from mrc Goes ‘Responsive’

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow
  • It Is Time To Have A Group Chat About AI
  • 2023 IBM i Predictions, Part 2
  • Multiple Vulnerabilities Pop Up In Navigator For i
  • Participate In The 2023 IBM i Marketplace Survey Discussion
  • IBM i PTF Guide, Volume 25, Number 4

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.