Top Stories and Breaking News
(Mouse over headlines to see story abstracts)
Featured Product: SYSTEM i DEVELOPER
New Database Track at the Summit!
Rise to the i can . . . can you?
challenge at the RPG & DB2 Summit
October 4-6 in Chicago.
Get the latest tips & techniques on 7.3, RPG, Free Form, SQL, DB2, ILE, Web Services, RSE/RDi, web & mobile apps plus 1-on-1 advice from top experts Jon Paris, Paul Tuohy, Susan Gantner, Scott Klement & Ted Holt
New DB2 track features 7.3 enhancements + step-by-step Design/Build/Secure/Tune tips.
September 17, 2016: Volume 18, Number 38|
September 10, 2016: Volume 18, Number 37
September 3, 2016: Volume 18, Number 36
August 27, 2016: Volume 18, Number 35
August 20, 2016: Volume 18, Number 34
August 13, 2016: Volume 18, Number 33
Copyright © 1996-2016 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034
It seems increasingly likely to us that over the long haul IBM will get out of manufacturing all but the largest of its Power-based servers and its System z mainframe line, which by definition is big iron. There are a number of implications of this strategy for IBM i shops, of course, but let's be honest here. Connect the dots and this seems inevitable.
In the IBM i world, no software vendor has found as much as success as JD Edwards. Sold to PeopleSoft for $1.8 billion in 2002 and now a part of Oracle, JD Edwards was the gold standard by which other ERP packages on the platform were measured. Now the principle founder of JD Edwards, Ed McVaney, is involved in another software startup in the Denver, Colorado area called Nextworld. But what does the company do?
It would be great fun to begin this article with news that IBM i enthusiasts were virtually lined up like box cars on freight trains to download Rational Developer for i (RDi), the modern graphical design tool for application development. It's not that dramatic. Sheer numbers don't tell the entire story, however. There's a bit of detectable momentum. What are the chances IBM will help that momentum grow? It's actually better than the pessimistic answer: slim and none.
The chilling reality of IT security weaknesses is widely overlooked and often assumed to be something that only affects someone else's business. A close look at our own organizations makes us uncomfortable. So do stories that include expert opinions that every business should begin its security review with the realization that a security breach has already occurred. That's how real the threat is. And your current security policy, if you even have one, is probably obsolete.
I'm an RDi fan. I make no secret about that. Even so I occasionally find things that I need to do that just seem easier or faster to do with PDM in the green screen. I don't really mind that. I nearly always have a green screen session sitting just next to my RDi workbench anyway. But when I can find a way to do a function as easily in RDi, I prefer to do that so that I don't need to switch modes as much.
The SQL Procedures Language (SQL PL) has an effective error-handling mechanism--condition handlers. When a statement returns a certain SQL state or a certain type of exception, the condition handler takes control. However, determining which SQL state to test for can be problematic. Here are two ways.
I have a table with a long list of column names and I want to build a SELECT statement from the catalog metadata. If I supply schema (library) and table (physical file) names, is there a way to generate a SELECT statement?
When Bernie Madoff's massive Ponzi scheme collapsed in 2008, erasing $65 billion in supposed wealth, the midrange community was somewhat surprised to learn that an AS/400 was at the heart of the operation. Soon thereafter, FBI agents called Rochester, Minnesota, with a request for IBM: Give us an expert witness who can untangle the ancient RPG II code and explain how it works to a jury. That job eventually fell to longtime IBMer Rich Diedrich.
Two years ago, Micro Focus started building out its software empire in legacy systems with the acquisition of the Attachmate conglomerate, a company that was bigger than itself at the time. And now, Micro Focus has done it again, this time by eating the bulk of the software that is currently owned by Hewlett Packard Enterprise, which has lost all urges to try to build a complete hardware-software-services stack like IBM used to have back in the 1990s and 2000s.
If you like creating applications in the Rational Developer for i integrated development environment, and you also like Apple Macs, then IBM has a release update for you.
It's not uncommon for people to overlook the IBM i Power Systems platform when it is data warehouse project planning time. Laura Hamway sees things differently. Hamway is a consultant who works primarily with manufacturing companies running Infor's LX ERP systems, which most people refer to as BPCS, the name of the software before the Infor acquisition. She helps these organizations consolidate data from multiple systems, which allows a single, summary view. More analysis. Less inefficiency. Better business.
The IBM i community is best known for its RPG programmers and its steadfast loyalty to a computing platform with blue-collar traits such as handling heavy workloads without a flock of nannies tending to its special needs. Behind the uncomplaining "workforce in a box" is a mix of application development environments and programs that are a combination of packaged products from the IBM midrange vendor community and home grown application handiwork.
When I read your statement that CL cannot write to printer files, I immediately thought, "It can't? Then what have I been doing for the last couple of decades?" I looked through the article and saw that it didn't mention my most used method, and I wondered how it was missed.
Sending Escape Messages from RPG is a great article. Your program defines the message data parameter as 80 bytes of character data, but the IBM Knowledge Center defines MSGDTA as char(*) with notes saying it can be up to 32,767 bytes. I would like a variable longer than 80 bytes, but instead of coding 100 today, 120 next project, and so on, how could I code it to take full advantage of the API?
Running CL commands and submitting batch jobs are great ways to use existing program functionality from a .Net desktop, web, or web service application. In this article we'll focus on the XMLSERVICE remote command functionality. You'll see just how easy it is to use XMLSERVICE to run programs or submit batch jobs on your IBM i systems.
In about a year or so, a radically different Power processor family will be embedded as the motors in the Power Systems machines that will drive IBM i applications into the future. The forthcoming Power9 chips, which IBM's top techies unveiled at the Hot Chips conference in Silicon Valley last week, are as always packed with lots of technical innovation. But that is not the main thing that IBM i shops should be ebullient about.