Re: Command / Utility to display a journal data of specif file

If I understand what you're after correctly, then I just wrote a little
utility along those lines last week. Basically, using SQL, I:

1. Create a new table LIKE the table being journaled
2. Select the first column/field name of the table being journal/displayed
(SYSCOLUMNS and ordinal_position = 1)
3. Alter the table made in step 1 using the alter table add column x
before y support (with y being the value found in step 2) to add the
various columns DSPJRN generates
4. Run DSPJRN and show the results

All can be done with CL (though I did use a RPG program for Step 2 as CL
doesn't exactly handle Selects real well).

There are many ways to do this, the above being the approach I took for
expediency.



On Tue, Mar 31, 2020 at 1:55 PM Peter Dow <petercdow@xxxxxxxxx> wrote:

DBU from ProData has a journal display option that breaks out the
entry-specific data into the fields for a specific file.

It's worth getting for its other features as well.


On 3/31/2020 8:01 AM, gio.cot via MIDRANGE-L wrote:

Hi all

I'm looking for a commad / utility that show me the journaul entry field

for

field of a specif file; in the past it semms to me, to read about this,

but

today i am not able to find again this link . Can some can help me ?

Thanks in advance

Gio

--
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