Timothy Prickett Morgan
-
RPG Talks To Watson
September 27, 2016 Paul Tuohy
… Read moreNote: The code accompanying this article is available for download here.
Yes, RPG can talk to Watson. No special software required, nothing to install, nothing to configure. You just need to be on V7R1, have the ability to use embedded SQL and write just a few lines of code–none of which are complicated. To see how it works, all you have to do is copy/paste the display file and RPG code in this article, compile and call.
On the off chance that you don’t know what Watson is, Watson is the IBM computer that, in 2011, competed
-
With Avnet Deal, Tech Data Spans From Glass House To Your House
September 26, 2016 Timothy Prickett Morgan
… Read moreAnd then there were three. For the past several years, the two dominant master resellers of Power-based systems–that would be Avnet and Arrow Electronics–who also sell a whole lot of other kinds of IT gear into datacenters, got a little competition from Tech Data and Ingram Micro joined the fray and started peddling Power gear and related storage.
Rather than compete with Avnet, Tech Data decided to shell out a whole lot of money to buy its Technology Solutions division, thus vaulting itself into a better competitive position in the IT distribution business relative to Arrow and making it
-
New OpenPower Servers Present Interesting IBM i Possibilities
September 19, 2016 Timothy Prickett Morgan
… Read moreIt 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.
Back in the AS/400 days, IBM made a custom machine, complete with homegrown processors and auxiliary compute, its own memory, and its own disk drives. When IBM started converging the AS400 and RS/6000 lines on the
-
Generate SELECT For All Columns
September 13, 2016 Hey, Mike
… Read moreI 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?
—Four Hundred Guru Reader
Thanks to dynamic compound statements and global variables, the answer is yes, it’s fairly easy to construct a SQL statement for a table or view as shown below:
/* Build Select Statement and stuff it in QGPL.TEMPSQL variable */ BEGIN -- Fill in your table/schema name DECLARE @TABLE_NAME VARCHAR(128) NOT NULL DEFAULT 'SYSCOLUMNS'; -
Determine The State Of The Error
September 13, 2016 Ted Holt
… Read moreThe 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.
Let’s start with a simple stored procedure.
Create or replace procedure CreatePlants begin create table plants ( ID dec(3), Location varchar(16), primary key (ID)); label on table plants is 'Plant master'; insert into plants values ( 1, 'Lost Angeles'), ( 2, 'New Yolk'), ( 3, 'Last Vegas'); end
What could go wrong? Well, the
-
How Do You Do That With RDi? Part 1: Copy A Source Member
September 13, 2016 Susan Gantner
… Read moreI’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.
This tip is the first in a series on things that I find some
-
IBM Updates Rational Developer With Mac OS, Other Goodies
September 12, 2016 Timothy Prickett Morgan
… Read moreIf 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.
In announcement letter 216-143, Big Blue said that it was making the Mac OS client a peer to Windows and Linux machines with the V9.5.1 update to the RDi tool. To be ultra precise, RDi is now compatible with Mac OS X 10.11. IBM warns that some functions of RDi, such as program verifiers and syntax checkers, are not available on Mac OS, and it is not clear when or if
-
Micro Focus Embiggens Mightily With HP Software Buy
September 12, 2016 Timothy Prickett Morgan
… Read moreTwo 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.
HPE, which is the part of the Hewlett-Packard empire that includes the Four Ss of servers, storage, switching, and
-
Getting Started With IBM i, .Net, and XMLSERVICE Remote Commands
August 30, 2016 Richard Schoen
… Read moreRunning 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 this installment we’ll begin to tour the XMLSERVICEi .Net application code and samples, starting with the remote command call example. If you haven’t installed and set up the XMLSERVICE application code and created an Apache web server instance yet, please check out
-
Clouds Grow, But Can IBM i Follow?
August 29, 2016 Timothy Prickett Morgan
… Read moreUntil cloud computing–meaning virtualized compute, storage, and networking that is sold under utility pricing–is absolutely the norm in the data center, we will be talking about what is and is not cloud and how fast it is or is not. The prognosis is that investments in public cloud computing are going to continue to grow fast, much faster than the overall IT sector, which has been coasting along more or less level for years.
That placid surface on overall IT spending masks the churn underneath the surface, so don’t be fooled.
According to researchers at IDC public cloud spending is