Re: output of CPYTOIMPF?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Marc Rauzier
Sent: Wednesday, February 04, 2009 9:10 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: output of CPYTOIMPF?

McKown, John écrivait dans
news:674577CB5E17964BA9950A5325819A2C567952@xxxxxxxxxxxxxxxxxxxxxx
ce qui suit:

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.

You could aso try to setup a drda connection. The z application could connect to the ddm/drda server on the i and uses SQL commands to retrieve the data.

--
Cordialement

>From what I understand, there is no RDMS on the "z" side. They want to transfer the "DB2 data" to a "flat file" on the "z" and read it using COBOL.

Looks like just ftp'ing the PF to the "z" in BINary will work. Which is gratifying because it is what I thought of first. The person on the "z" is likely confused because you cannot do this with any other DB2 implementation.

--
John McKown Systems Engineer IV
IT

Administrative Services Group

HealthMarkets®
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.