What about using a DDM file? Then you just use the CL command CPYF within REXX.

CRTDDMF - can be set to be an *IP connection - points to the file on the other box - and I use file cuz that's what the command does - heh!

Or is it such that the remote table does not yet exist?


-------------- Original message --------------
From: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>

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.


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

Return to Archive home page | Return to MIDRANGE.COM home page