Re: How to Undo an SQL Insert

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

I thought there was not any journaling on this system, therefore that
solution, while elegant, will not work.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Mon, May 16, 2022 at 11:24 AM x y <xy6581@xxxxxxxxx> wrote:

> The RRN of the record is in the journal receiver entry, which consists of a
> control area (many fields, including the RRN), and a record image.
>
> On Mon, May 16, 2022 at 9:03 AM Greg Wilburn <
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > X2.  If anyone knows how to get the RRN for certain, that would solve my
> > issue.
> >
> > The legacy ERP does not have ANYTHING journaled...  the transaction files
> > do not have a unique key on the PF or LF.
> >
> > I understand what everyone is saying about journaling.  No convincing
> > needed.  But I cannot simply "turn it on" and risk messages all over the
> > given all the other programs that touch this file.
> >
> > I'm also concerned about service program procedures (in the same module
> > even) that have COMMIT=*NONE.  I'm not sure how to handle that.
> >
> > If I was certain I could turn journaling on for this file, without
> > creating a host of other issues, I would.
> >
> > Open to suggestions