Re: SQL of Journal Entries

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

If you break it down into bite size chunks do you get anything?
select * from
wrkart/jrnhdr00 f
where f.bdt = '0001-01-01'
;
select * from
wrkart/jrnhdr00 t
where t.bdt <> '0001-01-01';

And, how did you export it to get all the columns available?

On Mon, Feb 10, 2025 at 12:31 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

> I'm trying to find what program changed BDT Date.  I have exported the
> journal entries into JRNHDR00.  This SQL returns zero results. Am I doing
> it right?  RID is the key of the table I journaled.
>
> select * from
> wrkart/jrnhdr00 f
> *left* join wrkart/jrnhdr00 t on f.*rid* = t.*rid*
> where f.bdt = '0001-01-01'
> and t.bdt <> '0001-01-01'
> --
> 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.