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

Yes that is correct; I would PREFER to remove the UNIQUE attribute, while leaving the field intact as a key.

If that were not possible, then I would accept dropping the field and re-adding the field as a non-unique key.

Goal:

I am running a TEST pgm which outputs to a file, and also running [almost the same version with a few small changes] PROD pgm.

I want to run CMPPFM but the key field (which is an incrementing seq#) is one-off at times.

I thought an easy solution would be to clear that seq# prior to CMPPFM, but the UNIQUE constraint wont allow that.

If I can SQL ALTER the field to remove the UNIQUE constraint, then set all keys to zero, then I could compare the TEST vs PROD versions of the file using CMPPFM.



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

Didn't he ask how to remove just the UNIQUE attribute?

----- Original Message -----
Chuck,

He asked how to remove the key. I showed him how to do it.

I assumed he could figure it out how to add the key back by rerunning the
...ADD PRIMARY KEY... But after seeing his reply where he blew off the
detailed steps I'm not so sure.


Rob Berendt