• DB2 for i 7.2 Features and Fun: Part 3

  September 10, 2014 Michael Sansoterra

  In the second tip of this series, I explored three new features introduced in DB2 for i 7.2: KEEP IN MEMORY clause; AUTONOMOUS PROCEDURE; and the CHECK CONSTRAINT VIOLATION clause. This tip aims to keep the momentum going by exploring a handful of remaining miscellaneous features, in no particular order. TABLE_NAME And TABLE_SCHEMA Scalar Functions These two new functions exist in the SYSIBM schema and are used to lookup base information about an alias. Say an alias is defined on a DB2 remote system table on a system named WASHINGTON: CREATE ALIAS DATALIB.WASHINGTON_TRANSACTIONS FOR WASHINGTON.ADVWORKS.TRANSACTIONHISTORY; The following VALUES statement will

  … Read more

• The Nearly Forgotten DSPLY Operation

  September 10, 2014 Paul Tuohy

  I am sometimes asked strange questions at conferences. A recent example is: “Which operation code do you use most in RPG?” After overcoming my initial reaction of wondering what the questioner was smoking (and where I could get some), I gave the question some thought. And the answer is: The DSPLY operation. Now, before you start to wonder what I am smoking (and where you can get some), let me explain. Firstly, the DSPLY operation will never see its way into production code, I only use it in test programs (more in a minute). Secondly, and what a lot of

  … Read more

• JD Edwards Gets 57 New Mobile Apps

  September 9, 2014 Alex Woodie

  You’ve heard of ’57 Chevys and Heinz 57. Now Oracle is taking a whack at the number by delivering 57 new mobile apps for the JD Edwards ERP system. As you might expect, the new mobile apps that Oracle unveiled in late July work only with the EnterpriseOne ERP system. While the company two years ago said they were evaluating the creation of mobile apps for World, which runs only on the IBM i OS, it has yet to deliver any. EnterpriseOne, of course, runs on IBM i, Linux, and Unix OSes. New app areas include: Asset Lifecycle Management, Service

  … Read more

• Food Company Gets a Leg Up on Errors with CCSS

  September 9, 2014 Alex Woodie

  From time to time, a processing error would cause a truck to leave the Lipari Foods warehouse before electronic invoices were generated, which would sometimes lead to stores refusing delivery. Now, thanks to system monitoring software from CCSS, errors like this can be detected before they cause problems. Lipari Foods is a Michigan-based food distributor that delivers deli, bakery, packaging, seafood, confections, and groceries. Millions of square feet of warehouse space and a fleet of semi-trucks enable it to serve customers spanning 12 Midwestern states. A heavy reliance on Power Systems servers and IBM i software enables the family-owned

  … Read more

• Raz-Lee Makes Moves in UK and Latin America

  September 9, 2014 Alex Woodie

  IBM i security software developer Raz-Lee Security bolstered its international presence this month with the appointment of a UK-based reseller and the hiring of a sales manager for Latin America. Raz-Lee’s partnership with Proxmity will enhance the software company’s presence in the UK and Ireland–and possibly Scotland, if that country gains its independence. Based in the central English cities of Nottingham and Leeds, Proximity specializes in providing IBM i technical services. The company is also a reseller for BCD Software (now part of Quadrant Software) and is the only accredited partner in the UK for Infor ERP LX and

  … Read more

• MPG Squeezes Entire IBM i Server Lineup Into Mobile App

  September 9, 2014 Alex Woodie

  If you sell IBM Power Systems hardware or are doing any kind of capacity planning on them for customers, Midrange Performance Group‘s new Power Systems Navigator might just be the must-have mobile app of the year. The free app lets you browse the entire library of Power Systems hardware and see the dirty details on each one. For $20 more, you get to compare the servers to your current one. The new app, dubbed Power Systems Navigator by MPG, runs on iOS and contains a database of information about 1,802 different Power server configurations–basically every AS/400, iSeries, System i,

  … Read more

• IvanDoc Gives IBM i Documentation Tool a Web Interface

  September 9, 2014 Alex Woodie

  Earlier this year, a Malaysian software company by the name of IvanDoc Software Services completed the first implementation of IvanDoc Documentation, its IBM i cross-referencing and documentation tool that generates HTML output. The company is looking to get traction with IBM i shops around the world as they embark upon application modernization projects. Documentation tools are indispensable for programmers that need to develop or maintain IBM i applications, especially when they confront an unknown IBM i application that lacks good documentation. Knowing how the internals of an RPG or CL application work and the various dependencies that may exist can

  … Read more

• Quadrant Debuts New BI Bundle: Business i

  September 9, 2014 Alex Woodie

  Quadrant Software last week unveiled Business i, a new bundle of business intelligence and reporting tools aimed at IBM i shops. The new offering, which has its roots in the BI tools of BCD Software (now a Quadrant subsidiary), helps users extract data from DB2 for i and other sources, create ad hoc reports, and deliver them via secure Web-based dashboards–all without requiring much involvement by the IT staff. Business i provides a collection of BI and reporting tools aimed at helping connect business people with the data they need to make decisions. The software features a Web-based interface that

  … Read more

• Rocket Schemes DevOps Serenity with Aldon ALM Hub

  September 9, 2014 Alex Woodie

  Many organizations–even IBM i shops–are adopting agile development methods. While this approach has advantages, it creates friction with the operations folks tasked with getting changes into production. Last month, Rocket Software‘s Aldon division started rolling out its new ALM Hub functionality to help the two sides collaborate more effectively while still respecting separation-of-duty requirements. The two sides of the DevOps equation must work closely to successfully implement changes. Given the complexity and interconnectedness of today’s enterprise systems and the penalties for screwing up, collaboration is absolutely critical. And yet, developers and operators are mandated by laws like Sarbanes-Oxley, HIPAA,

  … Read more

• SunGard Gives IBM i App New Life with LANSA

  September 9, 2014 Alex Woodie

  There was a concern among the executives at SunGard Public Sector that the IBM i-based NaviLine product line was getting a bit long in the tooth. Customers were complaining about tired UIs, the company had just rolled out a new Windows app that does pretty much the same thing, and there was some hesitation to invest in it. But now that the first round of a major rewrite using Visual LANSA is complete, it’s apparent that the sturdy old app has some life left in it after all. Development on the NaviLine public sector application goes back decades at SunGard

  … Read more

Previous Articles Next Articles