Re: Temporal table journaling

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

I believe the default journal is set in the CREATE SCHEMA.  See also
STRJRNLIB
> A journal and journal receiver: A journal QSQJRN and journal receiver
QSQJRN0001 is created in the schema, and is used to record changes to all
tables subsequently created in the schema.

> To update or delete data from a versioned system-period temporal table,
both the temporal table and its history file must be journaled.

You might have to do it in this order:
alter table mytable drop versioning
endjrnpf mytable
endjrnpf myhist...
strjrnpf mytable newjournal...
strjrnpf myhist...
alter table mytable add versioning ...


On Tue, Aug 27, 2024 at 10:50 AM Gad Miron <gadmiron@xxxxxxxxx> wrote:

> Hello guys
>
> While  creating a temporal table with versioning recently,
> I've noticed that the table was automatically journaled to   QSQJRN   JRN.
>
> Can I set a specific journal of my choosing?
>
>
> TIA
> Gad
> --
> 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.