Timothy Prickett Morgan
-
EXTOL Helps IBM i Shop with Web Services . . . m-Power Delivers In-Memory Analytics . . . VAULT400 Racks Up Another Win
September 16, 2015 Timothy Prickett Morgan
… Read more
EXTOL Helps IBM i Shop with Web Services
CURT Manufacturing has been using the EXTOL EDI Integrator for i software from EXTOL International for over a decade. But when the tow-hitch manufacturer decided to expand its business on the Web, it needed something to accelerate its new ordering processes.
That’s when it tapped another product from the Pottsville, Pennsylvania, software company: EXTOL Business Integrator (EBI) Web Services. With EBI Web Services installed on the company’s Power Systems server, CURT Manufacturing found the solution it needed.
It’s all about ensuring that CURT’s back-end processes could deliver faster response times to requests
-
Another Reason To Use Unrequired Correlation Names
September 15, 2015 Ted Holt
… Read moreAlmost eight years ago I gave you two good reasons to use a correlation name when SQL did not require one. A recent experience revealed to me another good reason to use an unnecessary correlation name, and I am happy to be able to share that information with you today!
A colleague of mine had an SQL query that ran to completion but produced the wrong results. He asked me to take a look at it, and I’m glad he did, because the experience taught me something. Let me set up the situation for you.
Assume two tables: a table
-
A First Look At SQL Descriptors
September 15, 2015 Paul Tuohy
… Read moreSQL descriptors allow for incredible flexibility when it comes to constructing dynamic SQL statements and/or processing the results of a dynamic SQL statement. But, since this is an introduction, let’s look at how they can be used in constructing dynamic SQL statements and leave their use in processing results for a later article.
Assume we want to embed the following SQL statement in an RPG program:
select workDept, empno, firstname, lastname from employee where workDept = ? and hireDate >= ? and birthDate >= ? order by workDept, empnoThe difficulty we have is that comparison values may or may
-
Reader Feedback On A Hypothetical Future IBM i System
September 14, 2015 Timothy Prickett Morgan
… Read moreOver the past several issues of The Four Hundred, I have been talking about the gap between the impressive performance that IBM delivers with each successive generation of Power processors and the amount of capacity that the vast majority of customers need. Or, more precisely, the capacity that they don’t seem to need to run their core IBM i workloads, much to the chagrin of Big Blue, its reseller and ISV partners, and the rest of the IBM i ecosystem that is trying to make a living.
In addition to outlining that performance gap, with the help of
-
Taking The Power Systems Pulse With GM Doug Balog
September 14, 2015 Timothy Prickett Morgan
… Read moreIt is hard to believe, but we are most of the way through the third quarter and looking ahead to the final quarter of the year. There is a pretty big lag in time between the last bit of business that is done in every 13-week period and when large companies like IBM actually know how well or poorly they have done. In the case of the Power Systems division within Systems Group, and particularly with the IBM i portion of that business, Big Blue says as little as possible to quantify and qualify how the business is doing. But
-
How Do I Join Tables? Let Me Count The Ways
September 1, 2015 Ted Holt
… Read moreNormalization is the process of making sure that each datum is stored in the proper table. Storing data in the wrong place gives rise to anomalies, a fancy word for problems, and you have enough problems already. To make sense of normalized data requires that tables be joined. Do you know the methods to code a join with SQL and the advantages and disadvantages of each one?
Method 1: WHERE
When I first learned SQL, joining was done in the WHERE clause of the SELECT statement. Here’s an example.
select h.*, d.* from SalesOrderHeaders as h, SalesOrderLines as d where -
The Path To XML-INTO Happiness, Part 3
September 1, 2015 Jon Paris
… Read moreNote: The code accompanying this article is available for download here.
In part 1 and part 2 of my XML series, I introduced you to the basics of using RPG’s XML support. In this tip we begin to explore some of the challenges that you may face when processing commercial XML documents, and the support RPG offers to handle them.
Take a look at the snippet of an XML document below:
<ItemsXRef > <Header RefId="xxxxx" TimeStamp="2011-11-30T00:06:06.643Z"> <to id="nnnnnn" name="nnnnnn"/> <from id="nnnn" name="A Company in Canada"/> <TransactionType>ItemXref</TransactionType> </Header> <Items> <SKU> <SKUID>10050322</SKUID> <UPC>6866261486</UPC> <WIN>30269675</WIN> <StatusCode>A</StatusCode> </SKU> <SKU> ... <snip> ... </SKU> -
A Hypothetical Future IBM i System
August 31, 2015 Timothy Prickett Morgan
… Read moreA few weeks ago, in the main story in this newsletter, I showed you the Power processor roadmap running out past the Power10 chip in 2020 and later and talked about the contrast between the huge amount of processing capacity that IBM is delivering in its Power Systems line and the relatively modest amount of oomph that the vast majority of IBM i shops need to do their daily work to make their daily bread. The gap, as I showed, is quite large, and it will continue to be so if current trends for usage growth and capacity growth continue.
-
Set Your Library List From A Job Description
August 18, 2015 Ted Holt
… Read moreNote: The code accompanying this article is available for download here.
On August 4, 2015, I asserted that the proper residence of a library list is a job description. Talk is cheap. Now it’s time for me to put my money where my mouth is. I have a utility that gives me easy access to the library lists in job descriptions. I wrote this utility last year, and now I use it daily with great results. Today I make that utility freely available for you to use in your shop.
If I were to follow IBM’s naming convention, I
-
An Introduction to Processing XML With RPG, Part 2
August 18, 2015 Jon Paris
… Read moreNote: The code accompanying this article is available for download here.
In the first part of this series I introduced you to the basics of using RPG’s XML-INTO op-code. In that tip I showed how the provision of a count provided by RPG in the PSDS can be used to determine how many of a repeating element were processed.
However, as I noted at the time, this can only be used when handling a repeating outer element. But what if there is a repeating element within each of those outer elements? In this second part of the series we