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



I had never run CPYTOIMPF with debug active before. The things that look odd, to me, are: 1) one row fetched at a time, and 2) Attempting to read when all rows have been read.

What I dimly remember reading about SQLSTATE was it showed the value of the last operation, which explains the row not found message.

What would a more efficient SQL statement look like that accomplishes the same function as CPYTOIMPF?

John McKee

-----Original message-----
From: rob@xxxxxxxxx
Date: Thu, 25 Aug 2011 13:29:53 -0500
To: Midrange Systems Technical Discussion midrange-l@xxxxxxxxxxxx
Subject: Re: Batch file transfer with Client Access

Instead of ftping directly from DB2 I would first transfer it to a stream
file using Scott Klement's IFS tools. A test tool that I wouldn't put
into production because IBM keeps breaking it at every release is
CPYTOIMPF. (If you want to see why it's so slow and stuff try running
STRDBG before it and look at the strange sql.)

To run file transfer from batch is doable. First, get the remote command
daemon running on the PC in question. STW for that. Once you get that
then it's no big deal for the i to run RUNRMTCMD to the PC and fire off
the batch command file.


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: "Ketzes, Larry" <Larry.Ketzes@xxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 08/25/2011 02:14 PM
Subject: Batch file transfer with Client Access
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Howdy folks,
Im thinking the subject says it all, but we are trying to
do a file transfer from an iSeries system down to a PC. We are also (goes
without saying) converting ebcdic to ascii. The data contains packed
fields and this fact seems to have eliminated some of our first attempts
using FTP2 from Taatools and also SecureZip from PKWare.
We have been successful using file transfer (Client
Access) interactively. We now would like to test this file transfer as a
batch job. We would like to run the batch job on a server and pull the
file down.


Thanks, Larry
[cid:image001.jpg@01CC632E.F0018A60]

Larry Ketzes · Lead Infrastructure Engineer · MetLife International
600 King Street · Wilmington, DE 19801 · 302.594.2146
lketzes@xxxxxxxxxxx
Larry.Ketzes@xxxxxxxxx<mailto:Larry.Ketzes@xxxxxxxxx>



IMPORTANT NOTICE. The information in this email (and any attachments)
which is proprietary to American Life Insurance Company (ALICO) is
confidential. If you are not the intended recipient, you must not use or
disseminate the information. If you have received this email in error,
please immediately notify me by "Reply" command and permanently delete the
original and any copies or printouts thereof. Although this email and any
attachments are believed to be free of any virus or other defect that
might affect any computer system into which it is received and opened, it
is the responsibility of the recipient to ensure that it is virus free and
no responsibility is accepted by American Life Insurance Company for any
loss or damage arising in any way from its use.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.