× 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.



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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.