tables comparsion



IBM's Command List programming language & Restructured Extended Executor

Re: tables comparsion

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

Hello,

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,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 92 times

Re: Re: tables comparsion

 

Re: tables comparsion

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

what happened when You googled for
db2 compare databases

or
db2 compare tables

:mrgreen:

we are just wasting time on a TS unwilling to do the tiniest research by himself
cheers
enrico
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
enrico-sorichetti
Global moderator
 
Posts: 2706
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 139 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
Pedro
 
Posts: 579
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 41 times

Previous

Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post