×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
