×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
My previous boss (a VB and Access programmer) asked me if the system could
do pivot tables. This list pointed me to the same article. After I
installed it, and he ran a few tests, he fell in love with it. So consider
this a second-hand recommendation.
Jerry C. Adams
IBM i Programmer/Analyst
A lot of people my age are dead at the present time. - Casy Stengel
--
A&K Wholesale
Murfreesboro, TN
615-867-5070
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Wednesday, March 28, 2012 9:18 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL in iseries: how to remake a file
Rob,
An utility for creating pivot tables and SQL cross-tab queries can be found
in this (somewhat old) ITJungle article:
http://www.itjungle.com/mpo/mpo032703-story01.html
HTH,
Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
As an Amazon Associate we earn from qualifying purchases.