Re: SQL Alter table: can I remove the UNIQUE attribute from a key?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Joel

Look again at Chuck's post(s) about using CHGPF over a changed DDS source member - he's shown how to remove the UNIQUE attribute a couple times in this thread, I think - unless he's abandoned that approach.

Then you can change the values in the key field all you want.

Is that a column you can ignore for comparison? And once you compare, can you re-link the records to the key field?

Rambling here - sorry!

HTH
Vern

----- Original Message -----
OK but this thread doesn't state how to compare all columns while ignoring the key and NOT naming each individual column.

Is this possible?

> > Why use CMPPFM when SQL can compare the data? The SQL can easily
> > ignore the /key/ column and compare all of the row data as a SET;
> > see a very recent message from a somewhat recent thread about
> > /comparing/ using the EXCEPT in a UNION.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, May 02, 2013 2:35 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL Alter table: can I remove the UNIQUE attribute from a key?

   FWiW the "SQL" is unlikely to have been mentioned by most people even 
though they are offering an SQL statement.  If the likely statement is 
"SELECT", then use that token instead of "SQL".  Anyhow, one possible 
search:

http://www.google.com/search?q=comparing+union+except+2013+site%3Aarchive.midrange.com%2Fmidrange-l

   The above search yielded two threads [plus this one; for obvious 
reasons] from 2013.  One had the "2 days ago" conspicuously noted in the 
results:
http://archive.midrange.com/midrange-l/201304/msg01365.html
_i Re: Easy way to determine if two tables contain the same data ... i_
archive.midrange.com/midrange-l/201304/msg01365.html
2 days ago ... EXCEPT select * from table2) UNION ALL (select * from 
table2 ... On Thu, Mar 28,
2013 at 7:28 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote: D ... If 
you have a
need to compare the contents of two tables to determine if ...

Regards, Chuck

On 02 May 2013 12:22, Stone, Joel wrote:
> How can I find thread?
>
> I searched
>
> http://archive.midrange.com/midrange-l/index.htm
>
> for "sql union except"
>
> How can SQL compare all fields except the key field WITHOUT naming each field?
>
> CRPence on Thursday, May 02, 2013 2:00 PM  wrote:
>
> > Why use CMPPFM when SQL can compare the data? The SQL can easily
> > ignore the /key/ column and compare all of the row data as a SET;
> > see a very recent message from a somewhat recent thread about
> > /comparing/ using the EXCEPT in a UNION.