CPYTOIMPF produces a csv (comma separated variable) file intended to be
opened with Excel or another spreadsheet-type program. Whay you want is
a straight copy of the file in fixed format to go to the z. FTP will do
this just fine in binary mode from i to z. I worked for years on data
from a 370 (or its successors) written on tape or transmitted via SNADS
or even 3780 emulation from z to i. Both are fixed format, packed
decimals are the same, record separators are the same. Blocking (on
tape) is the same. For tape from i to z, you copy the database file to a
tape file that specifies ANSI format rather than SAVF format. FTP will
do the same thing.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of McKown, John
Sent: Wednesday, February 04, 2009 8:18 AM
To: Midrange Systems Technical Discussion
Subject: output of CPYTOIMPF?
I don't yet have an "i" around and the manual doesn't really say, so
could somebody tell me what the output from a CPYTOIMPF looks like? It
is suitable to be ftp'ed to another, non-i, system and then read by a
program?
A person on my "z" forum asked a question on how to get the contents
from a "DB2 table on the iSeries" to a "z" to be processed by an
application. Actually, what I first told him was to just ftp the file
because both the "z" and the "i" are EBCDIC based. I still think that
would work, but I'm unsure because I don't have an "i" to play around on
to see what actually happens.
John McKown
Systems Engineer IV
IT
Administrative Services Group
HealthMarkets(r)
Administrative Services Group
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com
Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential or proprietary information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.
--
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.
midrange.com
