08
Tue, Oct
2 New Articles

Should You Upgrade to V7?

Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Let's review the advantages of getting current.

 

We're not really "bleeding edge" people. Whenever a new version of one of our favorite tools comes along, we rarely update immediately. We let others suffer the "new release blues" for a month or three and then make the move once we are convinced that the release is stable and offers functionality that we want and need. Even then, Jon generally acts as the company's designated guinea pig, boldly going where Susan fears to tread. She takes the approach that when Jon has stopped swearing at something (yes, he does occasionally use words like "bother" as hard as that may be to believe) for three or four months, then it is probably safe for her to upgrade too.

 

So why are we telling you all this? Because we hope it will lend weight to our declaration that it really is time to put aside your old releases and move on. Certainly, the V6.1 upgrade is a bigger step than any since the move to RISC, but you've had 14+ years to recover from that, and it is well worth the effort.

 

We appreciate that for some of you the move to V6.1 may be problematic because some of the software in use on your system will not migrate. If this is your issue and is caused by the (in)actions of a recalcitrant or predatory software vendor, then be aware that there is help available. Ever since the GA of V6.1, IBM has provided a special email address for the sole purpose of assisting customers in handling such situations. There have been any number of situations in which vendors became much more reasonable after a call from IBM. If you do have a problem in this area, give it a try; the address is This email address is being protected from spambots. You need JavaScript enabled to view it.. Explain your situation, and who knows; perhaps your problem will disappear…or at the very least get a lot smaller.

 

There are many solid reasons for making the move away from V5, but since the major focus of our work is in the application development arena, that will be the main focus of this piece.

Database Enhancements

Where to begin? Let's start with the database. For us, as application developers, one of the major features of the V7 release is the enhanced support for XML. The database now supports an XML data type that can be used to store complete XML documents. There is also improved support for the decomposition of XML documents into relational database columns—a process sometimes referred to as "shredding," although that term has connotations that we find somewhat disturbing when considering database integrity! The process of generating XML documents from existing databases is also much simpler, and best of all, no additional product is required to obtain all of this functionality, which was previously only available via the XML Extender program product.

 

Not only can you now store XML documents directly in the database, but the OmniFind Text Search facility that was introduced in V6 has been enhanced in V7 to allow full text searching of such XML data. Since IBM's Dawn May introduced these new capabilities in her iCan blog, we won't go into more detail here.

 

Another worthy enhancement in this increasingly security conscious world is V7's column-level encryption. While it has been possible for some time to encrypt columns in DB2 tables, to take advantage of the facility required application program changes, something many shops were loathe to do. This new capability allows for completely transparent encryption of specified columns in a table, which can then be accessed through either SQL or native I/O options. It is interesting to note that IBM is not providing the actual encryption algorithms. Rather, it is encouraging tool providers to supply them. Currently, Patrick Townsend and Linoma Software have offerings in this area. Of course, this is not to say that you cannot write your own encryption routines using IBM's APIs, and indeed it is likely that open-source advocates in the community will come up with additional options.

 

Why do we say that this is an "interesting" development? Because it is a further sign that IBM has recognized that in this fast-moving world they can't do it all and need to open up some aspects of the system and encourage deeper participation by software vendors. Another example of this approach is Rational's Open Access for RPG (more on that in a minute or two).

 

There have also been significant improvements in SQL performance. The new Adaptive Query Processing can modify the query plan based on the operation of the query and can actually make changes while the query is running with the result that performance can be significantly enhanced. There are also new database tools to assist in monitoring long-running operations, and indeed it is now possible to cancel long-running queries.

 

One other database enhancement that is worthy of note is the introduction of arrays as a user-defined type (UDT). They can significantly simplify the definition of parameters for SQL procedures. Having always been taught that in the relational database world arrays were an absolute no-no, we were a little surprised at this announcement. Not as surprised probably as Dr. Codd would have been, and one has to believe that he is probably spinning in his grave at something approaching 60,000 RPM!

Languages and Programming Tools

Let's begin with RPG—what else? The V6 and V7 releases have continued to provide solid evidence that IBM has no intention of mothballing RPG. The language just goes on getting better and better. 

 

V6 gave us the ability to define files in subprocedures and, perhaps more importantly in the long run, to pass files as parameters. This feature seems to have escaped many RPGers, but it seems to us to offer some very interesting possibilities for writing reusable file-handling routines. But that's a topic for another article or two.

 

Also addressed in V6 were a number of size limitations that had been plaguing those of us who needed to use RPG to process large XML documents or otherwise handle large "lumps" of data like HTML streams. No more 64K restriction on individual fields or named data structures; now the sky (or at least 16Mb) is the limit.

 

V6 also saw the introduction of the TEMPLATE keyword—not a big deal in itself, but another symbol of RPG having "grown up" in that it facilitates the creation of your own data types, a standard facility in most other modern programming languages.

 

RPG programs can also now run safely in a multi-threaded environment, an important consideration if you are using a Java Application Server to provide your user interface and calling into back-end RPG programs to do the real work.

 

With V7, we were treated to enhanced capabilities for sorting and searching arrays, and long-overdue support for the use of Alias names. There were also a number of improvements in support for double-byte data, an important step in a world where internationalization of applications becomes more commonplace. Always remember what the first two letters in www stand for if you have any doubts as to the importance of this.

 

Other RPG-related enhancements include further improvements in the SQL precompiler and in V7 the ability for RPG to handle result sets, a long-awaited improvement that will make many of the SQLers in the RPG community very happy.

 

Of course, the V7 feature that garnered most of the headlines was the announcement of Rational's Open Access for RPG (OAR). IBM also took the very sensible and somewhat unusual step of making the product available for V6 as well as V7.

 

The two primary complaints about OAR have been a) that it carries a price tag (albeit a pretty low one) and b) that IBM did not itself introduce a native GUI handler to work with it. As to the first complaint, we are inclined to agree but also believe that this situation will not last for long.  As to the second, it is our belief that this was exactly the right approach. RPG, and indeed the IBM i in general, needs to open up more if it is to survive. IBM is just too slow on its feet to be able to adapt as rapidly as is needed today. IBM proved with WebFacing that it could almost get it right, but WebFacing all but drowned under the weight of the Java and WebSphere Applications Server knowledge needed to support it. Most RPG shops had neither the resources and experience nor the desire to maintain that kind of infrastructure. By the time IBM produced an app server lightweight enough for the task, it was too late; the opportunity had passed, and other tools had stepped in to fill the niche.

 

In fact, it is vendors of such tools that are exploiting OAR and showing just what can be done with it. looksoftware and Profound Logic have both introduced new tools based on the interface, and the future looks bright. Can OAR succeed? We would argue that if these new vendor tools are anything to go by, it already has— and we haven't even begun to see what can be done in areas such as Web services, Office integration, and much, much more. OAR could be a good enough reason to upgrade all by itself!

Other Languages and Tools

Having mentioned Java, we're reminded that V7 introduces a new 64-bit Java Virtual Machine (JVM) that is shared with the AIX and Linux operating systems. This new JVM optimizes Java performance and also includes significant data access performance enhancements. If you are using Java in your shop, this is another very good reason to move.

 

We're going to refer to the development tools as Remote System Explorer (RSE) because that seems to be the one name that IBM hasn't changed as it has repackaged its "container" from WDSC, to RDi, and (currently) Rational Developer for Power Systems (RD Power). In its latest incarnation, RSE sports new integrated screen and report designers, finally providing a replacement for the old CODE Designer tool (or indeed, SDA and RLU if you enjoy pain). While there are a couple of features that we miss from the old CODE Designer, for the most part this is a great enhancement. Being able to flip back and forward between WYSIWYG and source code entry modes is a huge plus. There are numerous other changes in the latest version of the tools, not the least being significantly reduced memory footprints and faster load and run time. When you come to consider whether you should move your developers from the ancient green-screen tools to the RSE environment, don't forget that at V6, the green-screen tools were "functionally  stabilized," i.e., they will not be enhanced beyond the V6 level. They will continue to work and be maintained but have not been enhanced to support V7 language features. Such enhancements will only be in the RSE tooling.

 

Although not strictly tied to the V6/7 releases as it will run on V5R4, Zend and IBM have also recently introduced Zend Server for the IBM i. PHP on IBM i has never looked better. This new server removes the requirement for a second Apache server, thereby significantly simplifying the installation and management of the system, and contributing to the significant performance improvements that Server offers. The product comes installed on all new systems and includes many new tuning and debugging features. We've been doing a lot of PHP work in recent months, and many of our customers are giving it a test drive. It is a good choice for an RPG-centric shop, and there are a lot of young programmers out there who can help you make the most of it. Best of all, as long as you introduce them to /Free RPG, they will also happily embrace that too; just don't show them the fixed-form stuff unless you want to turn them off.

Web Services, Etc.

In addition to shipping the Integrated Web Application Server (IAS), IBM now also includes a number of wizards designed to enable you to deploy RPG (and for that matter COBOL, C, and CL) programs as Web services. We've worked with this quite a bit in the last six months and are impressed by the speed and reliability of the resulting code. Once you get the hang of it, it really is a very simple process. There are similar wizards to enable you to consume Web services, but they are much less impressive. However, we are told by IBM that any minute now new tooling will emerge in this area, and we look forward to seeing how it compares with offerings such as Scott Klement's free HTTPAPI, which (along with PHP) is our go-to tool for Web service consumption right now.

 

While working with some of the good folks in Rochester on some problems we encountered with the IAS, we were introduced to their latest baby: the Application Runtime Expert for i. This is a terrific tool that allows you to verify the run-time attributes of an application to help resolve those tricky situations where an application is not starting or working properly. It checks hundreds of system components and settings to ensure that they have the correct attributes. For example, it checks file and directory authorities and attributes, the settings in property/http/xml configuration files, user profiles, system values, environment variables, and much more. Think of it as a kind of health check for your system. For us, it highlighted, among other things, the fact that we were missing a group PTF and had the wrong password settings on some important user profiles. Correcting these problems resolved our issues. But even better is the fact that once your system is up and running, it can take a snapshot, creating a template of the application "in action" that can be used to troubleshoot any problems that may arise in the future or when the application is deployed on another (theoretically) identical system. This is a chargeable feature, but the cost is small, and it will pay for itself many times over the first time you need to use it.

Wrapping Up

We could go on, but if we haven't convinced you by now, we never will. There's a lot to like in the V6 and V7 releases, but you'll miss it all if you stay back on V5R4, and it won't be long before that release goes out of service. Do you really want to run your business on an unsupported operating system? If you are already running on an unsupported release, which means anything V5R3 or earlier, then you really should think of moving as quickly as you can. Look at all the goodies waiting for you. And you'll sleep better at night!

 

Jon Paris and Susan Gantner

Jon Paris's IBM midrange career started when he fell in love with the System/38 while working as a consultant. This love affair ultimately led him to joining IBM.

 

In 1987, Jon was hired by the IBM Toronto Laboratory to work on the S/36 and S/38 COBOL compilers. Subsequently, Jon became involved with the AS/400 and in particular COBOL/400.

 

In early 1989, Jon was transferred to the Languages Architecture and Planning Group, with particular responsibility for the COBOL and RPG languages. There, he played a major role in the definition of the new RPG IV language and in promoting its use with IBM Business Partners and users. He was also heavily involved in producing educational and other support materials and services related to other AS/400 programming languages and development tools, such as CODE/400 and VisualAge for RPG.

 

Jon left IBM in 1998 to focus on developing and delivering education focused on enhancing AS/400 and iSeries application development skills.

 

Susan Gantner's career has spanned over 30 years in the field of application development. She began as a programmer, developing applications for corporations in Atlanta, Georgia, and working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close association with the Rochester laboratory during the development of the AS/400 system. She worked in Rochester, Minnesota, for five years in the AS/400 Technical Support Center. She later moved to the IBM Toronto Software Laboratory to provide technical support for programming languages and AD tools on the AS/400 and iSeries.

 

Susan left IBM in 1999 to devote more time to teaching and consulting. She co-authored one of the most popular System i Redbooks ever, Who Knew You Could Do That with RPG IV? She and partner Jon Paris make up Partner400, a consulting company focused on education and mentoring services related to application modernization. Susan is also part of System i Developer, a consortium of top educators on System i technology who produce the RPG & DB2 Summit events. Its members include Jon Paris, Paul Tuohy, Skip Marchesani, and Susan Gantner.

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: