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

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


This thread ...


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

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