Re: Removing keys from Keyed Physical File

[Robert Rogerson <rogersonra@xxxxxxxxx>]

Steve, the problem with the sql approach is that the journaled file has 
date field with DATFMT(*MDY).

So when I create the "table" the date field is created as *ISO (from 
what I can find sql can not do DATFMT) so the cpyf fails as the date 
field (in *MDY format) is not a valid *ISO date.

If I can't find a way to remove the keys so I can use CRTDUPOBJ then my 
next option is exactly like you said and a before insert trigger on the 
date field to format it correctly.

Thanks,

Rob

On 2/22/2019 2:10 PM, Steve Richter wrote:
> 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