• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Profound Logic Taps Node.js and COBOL For New Directions

    June 1, 2016 Dan Burger

    We’re hearing a lot about Node.js as open source topics are discussed with greater frequency in the IBM i community. On the other hand, COBOL gets far less attention than it deserves considering that 80 percent of enterprise business applications run on this sturdy code. Profound Logic, one of several IBM i vendors leading the way in modernization efforts, is including both these languages in its product roadmap. Profound’s CEO Alex Roytman explains why and why now.

    Let’s begin with Node.js. IBM i support for open source software has increased in recent years, but open source is not new

    … Read more
  • Fresche Brings the Heat(map) to Legacy Modernization

    June 1, 2016 Alex Woodie

    Before embarking upon a legacy modernization project, it’s important to do your homework. Not all IBM i screens are equal, but figuring out which ones are the most widely used is neither easy nor straightforward. This is the challenge that application modernization vendor Fresche Legacy hopes to resolve with the new heatmap solution that it’s building for its Newlook modernization suite.

    Guessing how users interact with legacy IBM i applications can lead to erroneous conclusions about how to proceed with legacy modernization. Instead, Fresche says the new heatmap software it’s developing will allow customers to gather usage data from the

    … Read more
  • LAG And LEAD Functions In DB2 for i 7.3

    May 31, 2016 Michael Sansoterra

    Database devs, you can kiss many of your cursors goodbye, because DB2 for i has two sweet new functions named LAG and LEAD that will allow you to extract a column value from a different row within the result set (relative to the current row) without programmatically looping through each row.

    From the current row, LAG instructs DB2 to look backward in the result set a specified number of rows and retrieve a value. LEAD allows DB2 to look ahead to a specified row beyond the current row and extract a value. In DB2 parlance, these new functions belong to

    … Read more
  • Global Temporary Tables And Host Variables, Take 2

    May 31, 2016 Ted Holt

    In Global Temporary Tables and Host Variables, I complained that DECLARE GLOBAL TEMPORARY TABLE does not permit me to use host variables. I presented two ways to circumvent the problem. Today I revisit the topic to show another way that was not available six years ago.

    First, create some global variables.

       create variable somelib.gv_Company   dec(3);
       create variable somelib.gv_Customer  dec(5);
    

    Then use those global variables in your program.

    exec sql
       set gv_Company  = :inCompany;
    exec sql
       set gv_Customer = :inCustomer;
    exec sql
       declare global temporary table Temp1 as
           (select *
              from sales
             where companyno  = gv_Company
               and customerno = gv_Customer)
         
    … Read more
  • Watch Your Data While Stepping Out With RDi Debug

    May 31, 2016 Susan Gantner

    In this latest in my series of tips on using the RDi debugger, I’ll talk about one of my favorite debug features–the Monitors view–and we’ll explore not just one or two, but four different options for stepping through program code a statement at a time.

    Stepping Out

    Just like with the green screen debugger, you can step through code a statement at a time. Figure 1 shows the various debug tool bar icons with those related to stepping through your code highlighted. The most commonly used options are the two arrows in the middle: “Step Into (F5)” and “Step Over

    … Read more
  • ProData Gets Graphic, Releases DBU for RDi

    May 23, 2016 Dan Burger

    IBM midrange shops with active development environments are taking an interest in modernization projects. And along with that, comes graphical development tools like Rational Developer for i, commonly referred to as RDi. As more companies find RDi useful, more ISVs realize plug-ins to RDi are in demand. ProData Computer Services just joined the list by offering an RDi plug-in to its popular data access utility called DBU.

    DBU RDi offers developers direct access to database files in graphical form and the capability to execute DBU functions from within the RDi Remote Systems Explorer (RSE) panel. In addition to the DB2

    … Read more
  • As I See It: The Other Intelligent Design

    May 23, 2016 Victor Rozek

    When you are 25 years old, a quarter century sounds very much like a lifetime, but it’s probably less time than the Kardashians collectively spend admiring themselves in the mirror. Still, in the time it took another generation to come of age and embark on their career paths, the law of cause and effect as it pertains to the job market was turned on its head: working people had become all but irrelevant to the creation of wealth.

    Nowhere is that more evident than in IT. While manufacturing has long since resigned from the nuisance of hiring Americans in favor

    … Read more
  • IBM Wheels And Deals To Get IBM i Shops Current

    May 23, 2016 Timothy Prickett Morgan

    We have been complaining a bit that IBM did not deliver new Power8+ processors and an expected bump in price/performance and lower prices as well to help stimulate the IBM i segment of the Power Systems business. But lo and behold, IBM is finally coming around to the idea that it has to actually do something to entice customers on old releases to move to the latest Power8 iron and to get their licensed program products and operating system on Software Maintenance.

    The latest deal, called the IBM i License Transfer Promo, was unveiled at the COMMON conference last week

    … Read more
  • IBM i Execs Put Database On The Map

    May 23, 2016 Dan Burger

    The IBM i roadmap goes nowhere without DB2 for i. It’s the database that drives the bus. With each release of the IBM i operating system and each of the Technology Refreshes that come between the releases, we find database enhancements prominent. And this isn’t going to change. At least for the foreseeable future, it’s a data-centric world.

    It’s not fair to say IBM i innovation is nothing but database. There’s a lot going on in other areas, but the success of the system has always been the integrated database and the future success of the system will absolutely depend

    … Read more
  • Clearlake Sees Vision Deal As M&A Platform In IBM i Land

    May 23, 2016 Alex Woodie

    Clearlake Sees Vision Deal As M&A Platform In IBM i Land

    Vision Solutions, the dominant player in the market for IBM i high availability software, is being sold by Thoma Bravo to Clearlake Capital Group. The transaction, which is expected to be completed by the end of June, will give Clearlake a platform for pursuing more acquisitions in the IBM i ecosystem, a spokesperson with the company told IT Jungle.

    Thoma Cressey, as the San Francisco-based private equity firm was then known, obtained Vision Solutions with its acquisition of Idion Technology Holdings way back in September 2006

    … Read more

Previous Articles Next Articles

Content archive

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

Recent Posts

  • Power11 Entry Machines: The Power S1124 And Power L1124
  • BRMS Isn’t The Only Backup Product With A Security Problem
  • Guru: A Faster Way To Sign A JWT
  • Maxis Adds IBM i Support To Database Modernization Tool
  • IBM i PTF Guide, Volume 27, Number 28
  • To Comfort The Afflicted And Afflict The Comfortable
  • How FalconStor Is Reinventing Itself, And Why IBM Noticed
  • Guru: When Procedure Driven RPG Really Works
  • Vendors Fill In The Gaps With IBM’s New MFA Solution
  • IBM i PTF Guide, Volume 27, Number 27

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