• 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
    ARCAD Software

    [Podcast] IBM i DevOps Techtalk : 3-Part Series on Key Git Topics

    Listen in to these 3 short episodes as our experts Jeff Tickner, Ray Bernardi and Alan Ashley share their expertise on GIT, and discuss how best to use Git with the IBM i and its advantages.

    Moving To Git

    The topic of this IBM i DevOps TechTalk is “Moving to Git.”  It features Jeff Tickner, Ray Bernardi and Alan Ashley as they discuss what is Git and how to best use Git with the IBM i. Listen in for tips on:

    • Key Git Advantages
    • Git Considerations for a successful implementation
    • Working with branches and automated merges
    • Getting started and ARCAD’s Centralized approach

    Moving to Git – Gitflow

    Tune into this IBM i DevOps TechTalk on a key Git concept – Gitflow. Jeff Tickner, CTO NA, shares his knowledge and experiences from real-world implementations. Learn:

    • What is Gitflow and the benefits.
    • Bi-directional development with push/pulls and merging conflicts. Why you need this 2-way integration.
    • Flexible Gitflow options.
    • How ARCAD’s tooling elegantly supports Gitflow for the IBM i Developer

    Listen to this episode to get a jump on Git and partner with an expert on your DevOps journey.

    Moving to Git – The Build

    In this episode, we’ll discuss an important Git topic – The Build. If you are not using Git for IBM i source control, you are likely planning for it. A key part of the process you must understand is “The Build”.

    You may ask, why? Isn’t it just a standard IBM i build?

    No! Tune in as Jeff Tickner, CTO NA and Alan Ashley, Sr. Solutions Architect, discuss:

    • The differences between a standard IBM i build and a build with Git.
    • Understanding options and advantages with ARCAD versus Better Object Builder (Bob).
    • What are personal builds?
    • Advantages of automated builds with tools like Jenkins and Azure

    Partner with the leader as you make the DevOps journey to modern, agile IBM i development.

    Listen Now

    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

  • Rocket DevOps Now Supports VS Code
  • DR Testing As A Service: One More Thing That You Don’t Have To Do
  • The First Step In DevOps Is Not Tools, But Culture Change
  • As I See It: IT Come Home
  • IBM i PTF Guide, Volume 25, Number 39
  • ARCAD’s Deal with IBM for DevOps In Merlin Is Exclusive
  • In The IBM i Trenches With: Maxava
  • Is The Cloud On Your IBM i Horizon?
  • Four Hundred Monitor, September 20
  • IBM i PTF Guide, Volume 25, Number 38

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 © 2023 IT Jungle