If you have a Microsoft SQL Server laying around (2005 or above) you already have a good reporting tool available to you (SQL Reporting Services) which you can use to automatically email reports (PDF, Excel, XML, OData) to individuals on a timed basis and even allow for users to do self service BI with your DB2 data.
Matt Olson
Sr. Software Engineer
Phone: (651)681-3136
Email: matt.olson@xxxxxxxx
-----Original Message-----
From: Jerry C. Adams [mailto:midrange@xxxxxxxx]
Sent: Friday, April 20, 2012 9:40 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: iSeries Access Data Transfer Blowing Off
I am looking at alternatives, but would still like to know what went wrong.
More testing. When I changed the Where clause to " sistore#='717' and siperiod=20120420" it still blew off. But, if I closed the data transfer dialog box, restarted it, and used this syntax, it worked. Apparently, it seems, once data transfer gets this kind of error, at least, changing the options doesn't do one a whole lot of good; one has to start from ground zero.
Jerry C. Adams
IBM i Programmer/Analyst
We all get heavier as we get older because there's more information in our heads. -Vlade Divac, LA Lakers player
--
A&K Wholesale
Murfreesboro, TN
615-867-5070
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, April 20, 2012 9:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: iSeries Access Data Transfer Blowing Off
What are the users doing with the downloaded data? Are they loading it into Excel? If so then google for SQL2XLS. That will run an sql statement against DB2 and create an excel spreadsheet in your stream file system.
Then you can email that to them. No user interference. If you need more granularity than that provided by SQL2XLS then look at:
Excel with RPG and Java
http://www.scottklement.com/poi/
Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Jerry C. Adams" <midrange@xxxxxxxx>
To: "Midrange-L" <midrange-l@xxxxxxxxxxxx>,
Date: 04/20/2012 09:35 AM
Subject: iSeries Access Data Transfer Blowing Off
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Couple of questions regarding the Data Transfer function of iSeries Access
(V5R4 at OS V5R1).
First, I am trying to retrieve a select group of records from a table on the System i for output to a PC file. In the "Change Data Options" panel I have
Where: sistore#='717', siperiod=20120420
Order By: sitype, sicategory
I get a CWBC01047 error: The iSeries server application disconnected the
application.
I tried changing Where to sistore#='717' and siperiod=20120420 but got the
same error.
If I do not use the Where and Order By options (no selection), the
transfer
works fine.
Second, Is there any way, once I get the selection to work, to make the
selection dynamic; i.e., change the selection without interference from
the
user? Can the data transfer be invoked from a System i CL or RPG program
with, perhaps, dynamic options much like the RUNQRY command? I couldn't
find much about data transfer in the Info Center.
Jerry C. Adams
IBM i Programmer/Analyst
I think that the free-enterprise system is absolutely too important to be
left to the voluntary action of the market place. - Congressman Richard
Kelly (FL)
--
A&K Wholesale
Murfreesboro, TN
615-867-5070
midrange.com
