• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • SoftLanding Repositions TurnOver for Database Conversions

    August 19, 2014 Alex Woodie

    It’s been a while since we had any product news out of SoftLanding, the developer of the TurnOver change management tool that was acquired by Unicom Global nearly eight years ago. But earlier this month, we were apprised of a new release of TurnOver that introduces functionality in an area of IBM i development that’s starting to get some traction: DDS-to-DDL database conversions.

    Undergoing a conversion from the old DDS data type to the newer DDL data type and SQL is not for the faint of heart. The vast majority of IBM i applications were originally developed with the DDS construct in mind, so switching to the DDL data types and the SQE query engine is not something that can be done at a whim. But for those who successfully make the transition, the promise of a more modern and manageable database awaits, along with the prospect of getting another decade or two of use out of a proven RPG or COBOL application.

    IBM has offered some technical tips on how to successfully convert form DDS to DDL. While the folks in Rochester would undoubtedly prefer modern SQL to be the standard, Big Blue–forever cautious about upsetting customers–has not made much of a ruckus about the business benefits of taking the SQL route. Some independent software vendors, like TEMBO Technology Lab and Fresche Legacy (which acquired Databorough), have recently started to beat the drum about the need for DDS-to-DDL database conversions, and now we have SoftLanding joining the party, too.

    According to Unicom’s division, the new type code conversion functionality in TurnOver will help IBM i developers convert DDS files to the DDL format so they can be used in regular SQL tables. “SQL tables are easy to manage and manipulate and offer greater flexibility around application modernization as developers implement new interfaces for their legacy business systems,” SoftLanding operations manager Jim Fisher says in a press release.

    “Because SQL is a popular industry standard used in many different languages and technologies,” Fisher continues, “switching to DDL will also make it easier for the newer generation of developers to work with and maintain database applications. Converting DDS files to DDL is an important step towards future-proofing IBM i applications and it conforms with IBM’s roadmap recommendations for IBM i.”

    SoftLanding/Unicom didn’t offer many specifics about the new database conversion functionality in TurnOver. As an application lifecycle management (ALM) and software change management (SCM) tool for IBM i, one would think that TurnOver’s capabilities in the areas of object management, version control, code deployment, quality assurance testing, and issue tracking (not to mention cross-reference and database reorg functionality) could potentially be used in a database conversion project. Undoubtedly we’ll hear more about how TurnOver will help manage a SQL database conversion project.

    The new TurnOver release also brings compatibility with the latest fourth-generation languages (4GLs) in use on the platform. That means support for the latest LANSA 4GL environment, version 13.2, which is used in LANSA for IBM i, LANSA for the Web, and Visual LANSA development tools, as well as support for CA‘s latest IBM i 4GL, CA 2E version 8.6. Lastly, SoftLanding/Unicom tells us that TurnOver is compatible with the latest release of IBM’s integrated development environment (IDE), Rational Developer for i (RDi) version 9.1.

    It’s unclear what version the new release of TurnOver is, because the company didn’t identify it. The company currently labels its flagship ALM tool “TurnOver for iSeries v100,” a naming convention it adopted in March 2010 after it lost a court battle with an English software company and was forced to remove portions of TurnOver that appeared in versions 5.4 and earlier releases. Unicom/SoftLanding gave customers one year to upgrade to the new TurnOver for iSeries v100 edition, which did not contain the components to which it no longer was legally allowed to distribute.

    In addition to the core TurnOver for iSeries v100 product, SoftLanding/Unicom offers several add-on modules, including: TurnOver for LanTurn v100 (which provides LANSA functionality); TurnOver for Over:2E v100 (which provides CA 2E functionality); TurnOver for PDQ v100 (which provides data promotion capabilities;) TurnOver for ProTurn v100 (which provides support for BCD‘s ProGen Plus 4GL tool); and TurnOver for SVN v100 (which supports the open source Apache Subversion code tracking tool). For more information see www.softlanding.com.

    RELATED STORIES

    UNICOM Loses Appeal of SoftLanding Lawsuit

    UNICOM Loses in Court, Forces SoftLanding Customers to Upgrade

    SoftLanding Systems Acquired By CICS Specialist Unicom Systems

    SoftLanding Completes Transition to Eclipse-Based Technology



                         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
    Krengeltech

    When it comes to consuming web APIs on your IBM i, your options often boil down to one of two things:

    First, you end up having to rely on a variety of open source and non-RPG solutions. This adds developer complexity, taking away time that could have been better spent invested in other projects. Of course, open source software is free, but generally comes at the cost of no professional support, which adds an element of risk in your production environment. RXS is completely professionally supported, and is complemented by a staff of trained IBM i developers who can address your nuanced development challenges, head on.

    Second, if you choose not to pursue an open-source solution, you’re often left having to shake up your current program architecture with proprietary software, external dependencies, and partial RPG implementations – many of which are sub-par compared to RPG-XML Suite’s wide range of features. RXS aims to simplify the efforts of developers with tools like code generators, useful commands, and subprocedures written in 100% RPG – no Java. Because they are entirely RPG, the RXS subprocedures are easy to add to new or existing ILE programs and architecture, helping to cut your development time. RPG-XML Suite offers powerful capabilities in an accessible, easy-to-implement format.

    With RPG-XML Suite, you can accomplish a variety of complex tasks, such as:

    • Calling REST and SOAP web services from your IBM i
    • Offering APIs from your IBM i
    • Creating JSON & XML
    • Parsing JSON & XML
    • Text manipulation, Base64 encoding/decoding, CCSID handling, hashing and encryption functions, and more.

    To try RXS for yourself, we recommend a free proof of concept, which not only gives you access to all of RPG-XML Suite’s subprocedures and utilities but also includes a tailor-made software demonstration that can be used as a starting point for your future API implementations.

    For a free proof of concept, contact us at sales@krengeltech.com, or visit our website for more information.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    RJS Software Systems:  Webinar: Top 5 Problems Solved by Automated Report Delivery. August 26.
    System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Minneapolis, Sept 30 - Oct 2.
    COMMON:  Join us at the COMMON 2014 Fall Conference & Expo in Indianapolis, Oct 27-29

    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

    Manta Continues To Take The IBM i To School Partners Need To Get Certified–For Power8 And IBM i

    Leave a Reply Cancel reply

Volume 14, Number 15 -- August 19, 2014
THIS ISSUE SPONSORED BY:

ProData Computer Services
Enforcive
Shield Advanced Solutions
Computer Keyes
RJS Software Systems

Table of Contents

  • DRV Unveils Fresh New Mobile Apps for Message Management
  • Nice Form! Quadrant Boosts Automation and Control in Formtastic
  • VAI Gives Berk Enterprises a New Analytic View
  • SoftLanding Repositions TurnOver for Database Conversions
  • Townsend Looks to Spread 2FA Far and Wide
  • LaserVault DMS10 Unchains Your Documents
  • Kisco Solidifies Self-Service Password Reset Tool
  • S4i Goes IASP with Document Management Tool for HA Protection
  • Zend Peers Deep into Your Code with Z-Ray
  • Tango/04 Lunches Alignia to Simplify Corporate Monitoring

Content archive

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

Recent Posts

  • IBM i 7.3 TR12: The Non-TR Tech Refresh
  • IBM i Integration Elevates Operational Query and Analytics
  • Simplified IBM i Stack Bundling Ahead Of Subscription Pricing
  • More Price Hikes From IBM, Now For High End Storage
  • Big Blue Readies Power10 And IBM i 7.5 Training for Partners
  • IBM Delivers More Out-of-the-Box Security with IBM i 7.5
  • Groundhog Day For Malware
  • IBM i Community Reacts to IBM i 7.5
  • Four Hundred Monitor, May 11
  • IBM i PTF Guide, Volume 24, Number 19

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.