Re: What cmd is used to cpy from an IFS stmf to another IFS stmf, adding records?

On 11/17/2015 6:34 AM, rob@xxxxxxxxx wrote:

Justin,

I would find your technique onerous to the system.

I agree. I was just suggesting how I would do it from a pure green screen
setting.

Then there's the temporary space to consider. If you have a 10GB stream

file being posted into your 200GB stream file and you copy them into DB2,
do the merge, and then put them back outside of the qsys.lib system it
really starts to add up.

In that scenario, my 1st question is why do you even need a 210GB CSV that
your periodically appending data to. It seems to me that a bunch of
compressed CSV files would do better. Naturally, replace CSV with EDI, or
other efficient format.

Now, if you were dealing with small amounts of data, I'd actually suggest
using xml with a well defined XSD schema. A lot of CPU and IO overhead in
exchange for validation that gives well defined errors that can be
duplicated on both sides of the transmission.

Justin