RE: FTP between LPARs doesn't produce the same row numbers

["Evan Harris" <spanner@xxxxxxxxxx>]

Hi Dave

> From what you have said so far, using SAVRSTOBJ would be a better approach
in my opinion, but it might help if I understood more about the entirety of
what you are trying to accomplish.

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Saturday, 28 June 2008 8:20 a.m.
To: midrange-l@xxxxxxxxxxxx
Subject: Re: FTP between LPARs doesn't produce the same row numbers

Chuck and CR,
 
Thanks much for the info.  Now... what's the best way to skin this cat and
I'm not "set" on FTP.   I need to use REXX to automate a "copy" of a set of
tables between two i5 LPARs; from Production to a Data Warehouse.   The
table/file format will be the same (created from DDS)... for now.  I'm
looking for the fastest way to make the move, automate the move using REXX,
be assured there will be no surprise additions or deletions, etc.   Heck, if
I could do a cross partition INSERT ... SELECT and it would run fast, I'd do
that.
 
If the best way turns out to be FTP, what's involved in doing the BINARY
"conversion" on either end; not sure that sounds good or easy if that has to
be done outside of FTP but maybe I'm wrong.  Do I understand you all to say
that TEXT mode with BLOCK would accomplish what I'm looking for?   I guess
there is a lot about FTP I don't understand, especially on the i5; educate
me.
 
Thanks,
 
Dave