• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • PTC Completes Database Support In Implementer

    September 11, 2019 Alex Woodie

    As a change management tool, PTC’s Implementer is well-regarded among IBM i users for its ability to track development tasks and smooth out the promotion process. While the product has mostly been used to track source code in programming languages like RPG and Java, customers have increasingly been putting business logic into Db2 for i. With the recent launch of Implementer 12.3, PTC has wrapped up planned enhancements for the database.

    PTC‘s Implementer provides a full range of capabilities for managing development processes for IBM i shops. The software works closely with IBM‘s Rational Developer for i (RDi) to provide a single point of control for versioning, code promoting, and task assignments, without requiring the developer to ever leave RDi. It also has been adapted to work with popular ERP systems like Oracle‘s JD Edwards World and Infor‘s ERP LX packages, as well as LANSA and CA 2E development environments.

    The first phase of PTC’s renewed database support in Implementer started with last year’s launch of Implementer 12.2. That release added support for physical file and database triggers. (The product already kept track of stored procedures and built-in functions, or BIFs.)

    In version 12.3, which debuted in April, the company added support for managing database constraints at an object level. That will help customers better manage their development efforts, says Dawn Blohm, PTC’s technical support manager for Implementer.

    “I would say one of the biggest things in 12.3 is we finalized Implementer’s handling of object attributes, with triggers and constraints,” Blohm said at COMMON‘s POWERUp conference held in May. “That’s both on physical files, logical files, and also SQL.”

    When being used with traditional DDS files, Implementer can manage database constraints at an object level. For physical files and non-source tables, constraints can be defined as user-defined attributes, the company says.

    Constraints are also supported when used with SQL databases. In release notes for version 12.3, the company says: “During promotions, any constraints defined within the source member will be defined on the target object and any constraints on the target object that are not defined within the source member will be removed.”

    The database updates get the headlines, but there are several other enhancements of note, including faster communication between a local hosts and remote servers. Blohm says the company has worked to ensure that job logs are returned from the remote server much quicker than in the past.

    “We’ve also obfuscated sensitive information in the Implementer server job log,” she says. Previously, the password for the user profile that the Implementer server job log ran under was stored in plain text, which would constitute a security threat.

    Lastly, the company has cleaned up how it handles SQL views and materialized query files (MQTs). Implementer will now use a new IBM parse statement function to determine dependent files when processing SQL views and MQTs.

    Implementer version 12.3 is available now. The software supports IBM i 7.4 and previous releases of the operating system. For more info, go to www.ptc.com.

    RELATED STORIES

    PTC Refines Handling Of IBM i Database Logic

    Where’s MKS Implementer? Alive and Well At PTC

    CAD Vendor PTC Has Designs on ALM Vendor MKS

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: BIF, built-in functions, DB2 for i, IBM i, Java, materialized query files, MQT, PowerUp, Rational Developer for i, RDi, RPG, SQL

    Sponsored by
    ARCAD Software

    [Webinar Series] Demystifying DevOps on the IBM i

    Join us for this 3-Part Roundtable Webinar Series, where ARCAD experts will demystify the move to Git and an automated process with options that work for everyone!

    This Series will be an engaging discussion on key DevOps topics as Git, Builds, Automation and much more.

    Part 1: IBM i & Git – Developer Tools (Thursday, January 26th, at 12:00PM ET / 9:00AM PT)

    During this 1st session, we will discuss Developer Tools and all the ways to use Git including iProject, Merlin, VS Code, ARCAD’s Centralized option and more.

    Part 2: Branching & Building (Thursday, February 9th, at 12:00PM ET / 9:00AM PT)

    During this 2nd session, we will discuss Feature/Release and Branch Management and building the branches with tools like Bob and ARCAD.

    Part 3: DevOps – Automated Workflow (Thursday, February 23rd, at 12:00PM ET / 9:00AM PT)

    During this 3rd session, we will discuss what can be automated in the IBM i DevOps process starting from the build to other steps in your workflow.  We’ll discuss pipeline tools like Jenkins and the new automation features of Git packages.

    Register NOW

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Fresche Hires Database Modernization Expert IBM i Headed To Azure By Way Of Skytap

    Leave a Reply Cancel reply

TFH Volume: 29 Issue: 50

This Issue Sponsored By

  • ProData Computer Services
  • Eradani
  • Dawn May Consulting
  • Maxava
  • T.L. Ashford

Table of Contents

  • IBM i Headed To Azure By Way Of Skytap
  • PTC Completes Database Support In Implementer
  • Fresche Hires Database Modernization Expert
  • Four Hundred Monitor, September 11
  • IBM i PTF Guide, Volume 21, Number 36

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.