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?
Compare DB2 table in both TEST and Prod regions,
- Anuj Dhawan
- Founder
- Posts: 2802
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Compare DB2 table in both TEST and Prod regions,
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.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute