tables comparsion

IBM's Command List programming language & Restructured Extended Executor

Re: tables comparsion

Postby dick scherrer » Sat Jan 05, 2013 2:38 am


but I want to do without unloading...
As the Rolling Stones said many years ago, "You can't always get what you want" . . .

Why do you even want this? Why not use the tools already available and do the unload / compare?

Is there some business or technical reason to use something other than the standard utilities that are part of the DB2 product?
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: tables comparsion

Postby enrico-sorichetti » Sat Jan 05, 2013 3:07 am

what happened when You googled for
db2 compare databases

db2 compare tables


we are just wasting time on a TS unwilling to do the tiniest research by himself
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: tables comparsion

Postby Pedro » Sat Jan 05, 2013 3:18 am

How about:
SELECT * FROM myschema.mytable1;   

while allocating SYSPRINT to a dataset.

Do the same for the second table then compare the two SYSPRINT datasets with SUPERC.

Of course, your test data should not be too simple. Most likely, your vendor will have tested simple things. You need to test to the length limits of LOB and XML columns, and so on.
Pedro Vera
User avatar
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times


Return to CLIST & REXX


  • Related topics
    Last post