Re: Removing keys from Keyed Physical File

[Steve Richter <stephenrichter@xxxxxxxxx>]

Rob,
I would try to use "create table xxx as ( select * from duppedTable ) with
data

that should create an SQL created table.   Then you can alter table and
remove the primary key?

-Steve


On Fri, Feb 22, 2019 at 2:02 PM 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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at 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