Re: Removing keys from Keyed Physical File

Robert,
Was it originally a PF created from DDS source?  If so, do you have the DDS source for it?
If so, you can make a copy, and remove the "K" lines (key specifications) and use CHGPF ... :D
CHGPF was added for Y2K projects, in the late '90s, and it compares the DDS source with the physical file, and then issues the equivalent of SQL "ALTER TABLE" under the covers.

(Be sure to point CHGPF at the copy of the PF you want to remove the keys from, and not the original PF ...)

Hope that helps,
Mark S. Waterbury

On Friday, February 22, 2019, 2:02:03 PM EST, Robert Rogerson <rogersonra@xxxxxxxxx> wrote:

Hi all,

I'm trying to create a journal extract file which will format JOESD from
DSPJRN.

I have it more or less working.  I use CRTDUPOBJ of the journaled file
and then ALTER TABLE to add the journal fields.

As I said I have this working.  The problem I just found was that the
CRTDUPOBJ still creates a keyed physical file.

Before I change the process to an all SQL solution I'm wondering if
anyone knows a way to remove the keys from the keyed physical file.

I haven't found a way but I thought someone else may of a way. If not
I'll use and sql approach...

Thanks,

Rob