iSeries Access Data Transfer Blowing Off

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