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

On 02 May 2013 07:55, Stone, Joel wrote:

The UNIQUE key to this file was created as primary from DDS.

Can I either:

1) Remove the UNIQUE attribute of the column using SQL ALTER, or

2) Can I DROP the field and ADD the column back to the BEGINNING
position (1st column)?

As a DDS PF, just modify the DDS to remove the UNIQUE file-level keyword, then issue the request to CHGPF the_PF SRCFILE(the_srcpf) SRCMBR(the_srcmbr) /* where the_srcpf and the_srcmbr are the source file and member of the modified DDS source member for the file the_PF */

Essentially that will effect the database physical file being re-created without the unique key, and the data /moved/ into the newly created file and the new PF access path built without the requirement of unique data for the designated K-specs across the records in each of the members of the file. I suppose there may be restrictions diagnosed against dependent LFs which prevent the action... for which decisions will have to be made about how to proceed.