Page 1 of 1

Compare DB2 table in both TEST and Prod regions,

Posted: Fri Jan 14, 2022 8:52 pm
by Prasad
I have one interview question if anybody knows answer:

There is a DB2 table in both TEST and Prod regions,

I wanted to compare both and restore test table with prod wherever it is not matching.

How can we do in COBOL-DB2 Program?

Re: Compare DB2 table in both TEST and Prod regions,

Posted: Fri Feb 11, 2022 2:18 pm
by Anuj Dhawan
One easy way to do that is - unload DB2 tables to datasets. Bring them to a single given region - either to Prod or Test. Now it's a two-file comparison situation.