Beginning with Version 8 in DB2/LUW, you can use a query similar to the
following:

SELECT TEMPID FROM APPLICANT
EXCEPT
SELECT TEMPID FROM INTERVIEW;

This query will select all of the rows in APPLICANT that do not exist in
INTERVIEW for the column TEMPID.

Or, use an * to check all columns, or list the specific columns, in both
tables to see which rows are different

Al Glinter, Lead Database Administrator
Federated Systems Group




"Parry Colin "
<db2udbdba-ezmlms
hield-x1183648.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
03/23/2007 10:15
AM Subject
Comparing DB2 tables ??










Does anybody know how we can compare the contents of two DB2 tables ??

Regards

Colin

> *Colin Parry
> GIS/TS/DBAs
> Computer Centre, Bootle
> *int: (8810) 3961
> *ext: 0151-966 3961
> *fax: 0151-966 2913
> * e-mail: colin.[Email address protected]
>
>


ALLIANCE & LEICESTER PLC - IMPORTANT NOTICE:

This communication, and the information it contains
a) is intended for the addressee named above and for no other person or
organisation, and
b) may be confidential and/or legally privileged and/or protected in law.

Access to this communication by anyone other than the addressee is
unauthorised. Unauthorised use, copying or disclosure of all or part of
this communication
is strictly prohibited and may be unlawful.

Unless the contrary is clear from its context, this communication does not
create or modify any contract.

If you are not the intended recipient, please contact the sender
immediately
by return e-mail and destroy all copies of this communication.

This communication may contain personal data. If so, you are required to
observe the provisions of any relevant data protection legislation in any
processing of such data.

Although this company has taken reasonable steps to ensure that this
communication and any attachments are free from computer virus, you are
advised to take your own steps to ensure that they are actually virus free.

Alliance & Leicester plc is authorised and regulated by the Financial
Services Authority. Our FSA register number is 189099.

Alliance & Leicester plc, Registered office : Carlton Park, Narborough,
Leicester LE19 0AL.
Company No: 3263713. Registered in England.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page