| View previous topic :: View next topic |
| Author |
Message |
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
 Posted: Tue May 10, 2005 11:47 am Post subject: Data comparision |
 |
|
Hi all,
is there any tool for comparing the data of two tables without downloading both into a differents files and compare these?
Kind regards. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Tue May 10, 2005 12:01 pm Post subject: |
|
|
Monaco,
Unless I am missing something , why can't you do it via Spufi or QMF?
| Code: |
SELECT A.KEY
,A.COMPARE_COL
,B.COMPARE_COL
FROM TABLE1 A
,TABLE2 B
WHERE A.KEY = B.KEY
AND A.COMPARE_COL <> B.COMPARE_COL
;
|
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Tue May 10, 2005 12:18 pm Post subject: |
|
|
Thanks Kolusu,
the problem is we want to compare the data of two tables with the same structure but problably different data in each column.
We dont have a 'KEY' column.
We are trying to compare 200 tables.
Thanks.
Kind regards. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Tue May 10, 2005 1:16 pm Post subject: |
|
|
| Quote: |
the problem is we want to compare the data of two tables with the same structure but problably different data in each column. We dont have a 'KEY' column.
|
Monaco,
Let us assume that you have 2 tables.
Table 1 has 10 rows and table2 has 20 rows.
So you want to compare the 1st row of table1 to the first row of table2 or do you want to compare the 1st row of table1 to ALL the rows of table2?
kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Tue May 10, 2005 4:01 pm Post subject: |
|
|
Kolusu,
We want to compare the 1st row of table1 to ALL the rows of table2.
Thanks. |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Wed May 11, 2005 8:46 am Post subject: |
|
|
Hope you can understand the example and sorry for my english.
I want to compare the data in two tables with the same structure. I'd like to know a ouput saying there are 3 rows in table 1 which are not in table 2 and 15 rows in table 2 which are not in table 1.
At the moment we download both tables and compare the files through
| Code: |
//SUPERC EXEC PGM=ISRSUPC,
// PARM=(DELTAL,LINECMP,
// '',
// '')
//NEWDD DD DSN=AISD.S3DA.INTESB30.KTCTVAT.CCOMPARE.S100305,
// DISP=SHR
//OLDDD DD DSN=AISD.S3DA.MASTSB30.KTCTVAT.CCOMPARE.S100305,
// DISP=SHR
//OUTDD DD DISP=(NEW,CATLG,CATLG),
// DSN=AISD.S3DA.COMPSB30.KTCTVAT.CCOMPARE.S100305,
// DCB=(RECFM=FB,LRECL=309,BLKSIZE=27810),
// UNIT=SYSDA,SPACE=(CYL,(1,9))
|
We'd like to find a similar output but without downloading the tables.
Kind regards. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Wed May 11, 2005 8:53 am Post subject: |
|
|
Monaco,
As far as I Know there is no utility which can compare 2 different tables. I guess you have to download the compare them.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
| Posted: Thu May 12, 2005 9:48 am Post subject: |
|
|
| Thanks for your help. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
