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




This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2019 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].