Re: Removing keys from Keyed Physical File

[Robert Rogerson <rogersonra@xxxxxxxxx>]

Thanks Glenn, I tries that too but it still created a keyed physical file.

Thanks,

Rob

On 2/22/2019 2:27 PM, Glenn Gundermann wrote:
> What happens if you use CPYF by RRN?Yours truly,Glenn Gundermannglenn.gundermann@gmail.comCell: (416) 317-3144
> -------- Original message --------From: Robert Rogerson <rogersonra@xxxxxxxxx> Date: 2019-02-22  2:01 PM  (GMT-05:00) To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx> Subject: Removing keys from Keyed Physical File 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-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing listTo post a message email: MIDRANGE-L@lists.midrange.comTo subscribe, unsubscribe, or change list options,visit: https://lists.midrange.com/mailman/listinfo/midrange-lor email: MIDRANGE-L-request@lists.midrange.comBefore posting, please take a moment to review the archivesat https://archive.midrange.com/midrange-l.Please contact support@xxxxxxxxxxxx for any subscription related questions.Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com