• The Dollars And Sense Of Business Continuity

  September 21, 2020 Timothy Prickett Morgan

  Those companies that have been in the IBM midrange market for a long time and are still alive and kicking have undergone a lot of change over the decades. But as is also the case, the core people at the company have been there for a long, long time and they understand how to leverage change to drive business and absorb change to help customers cope.

  That is one of the secrets of longevity for Datanational, founded in September 1979, which is located in the Farmington Hills suburbs of Detroit and which has always had a strong presence in …

  Read more

• Guru: SQL Can Read Program-described Data

  September 21, 2020 Ted Holt

  I thought I left program-described database files behind me in 1988. That’s when I left my last S/36 shop to begin working on the S/38. Well, I did, but not completely. From time to time I work on a system with program-described files, and even some externally described files have program-described fields. Fortunately — and I owe this to Scott Forstie — I have learned that SQL can read program-described data. Will wonders never cease?

  You may be thinking, “This article doesn’t apply to me. Our files are externally described.” You may be right. Then again, you may be wrong. …

  Read more

• CNX Releases Beta of Valence 6.0

  September 2, 2020 Alex Woodie

  CNX last week announced the beta release of Valence 6.0, the newest version of its Web development framework and portal for IBM i. Valence 6.0 brings a whole new look and feel to Web applications created with Valence, as well as updates to administrative functions, the data access layer, and more.

  Valence is a set of tools for creating Web and mobile applications that run under IBM i’s Apache Web server and access existing RPG business logic. The product has several components, including a JavaScript library; a set of RPG procedures for integrating various JavaScript libraries (Ext JS, React, or …

  Read more

• Guru: Reading Nested XML Using SQL

  August 31, 2020 Jonathan M. Heinz

  XML is a data-interchange format, not a relational database management system. For this reason, using SQL to query XML data can be challenging, as what would be stored in two relational tables are placed in one element of XML. To put it another way, detail data is nested under the header data.

  I would like to share a way of using SQL to extract nested data from an XML file. I found this method useful when testing a change to a process that creates XML to be sent to customers. I can use this SQL to quickly check that the …

  Read more

• Is It Time To Rename RPG?

  August 24, 2020 Alex Woodie

  Should IBM rename RPG, and if so, what should the new name be? It’s an interesting idea, and one that was recently floated by a member of the IBM i community, who submitted an official request for enhancement (RFE) on the matter. The crux of the argument is that full free-format RPG is such a dramatic departure from fixed-format RPG that it deserves a new name. But will IBM, which owns the language, go along with the change?

  Report Program Generator, or RPG, debuted way back in 1959, at the dawn of the computer age, as a way to replicate …

  Read more

• ARCAD Hooks Cross-Reference Tool into LPEX Editor

  August 19, 2020 Alex Woodie

  IBM i developers won’t have to leave the comfort of RDi and the LPEX editor to engage in application cross-referencing tasks, thanks to the recent integration between the ARCAD Observer cross-referencing software with LPEX.

  According to ARCAD Software, the new LPEX integration will bring “massive productivity benefits” to IBM i developers in the form of context-sensitive “where used” impact analysis, as well as dependency information, all delivered directly from within the LPEX editor.

  LPEX integration is a new feature delivered in late June in ARCAD Observer version 12.1. The company, which has offices in France, New Hampshire and Chicago …

  Read more

• Guru: Dynamic Arrays Come To RPG – The Next Part Of The Story

  August 17, 2020 Jon Paris

  In my first tip on this topic I covered the automatic sizing option (*AUTO) for the new dynamic arrays. In this tip I am going to look at the second option (*VAR), which allows the programmer to directly control the capacity of the array, growing and shrinking it as required. In addition I will also briefly cover the third option (*CTDTA) which, as you may have guessed, relates to compile time arrays.

  Using A Varying Length Array

  Let’s start with a brief example of using a variable sized array in conjunction with SQL. This approach answers the classic question of …

  Read more

• IBM Rolls Out ACS 1.1.8.5

  August 12, 2020 Alex Woodie

  IBM last week introduced a new release of Access Client Solutions (ACS), the popular IBM i client that’s used by administrators, programmers, and engineers alike. There are enhancements to Run SQL Scripts, new 5250 viewing options, and a performance boost for viewing selected files on the IFS with version 1.1.8.5, among other mostly minor updates.

  According to the release notes associated with the new iteration of ACS, IBM made a handful of changes with version 1.1.8.5.

  Let’s start with the improvements to Run SQL Scripts, which is an increasingly popular utility in ACS that leverages the power of SQL and …

  Read more

• Red Hat’s Ansible Automation Comes To IBM i

  August 3, 2020 Alex Woodie

  Big Blue is now supporting IBM i with Ansible, the open source configuration management software developed by Red Hat. By including IBM i and AIX as a supported target in Ansible, companies that run IBM i will be able to remotely configure and manage IBM i and AIX servers using the same Ansible tools and techniques that they use to manage mainstream X86 and cloud server environments.

  Ansible was created back in 2012 by Michael DeHaan, the author of the Cobbler provisioning server and co-author of the Fedora Unified Network Controller (Func) framework for remote administration. It’s been widely adopted …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

Previous Articles Next Articles