Re: Help with DSPJRN command

[Ashish Kulkarni <ashish.kulkarni13@xxxxxxxxx>]

Hi
I already have a RPGLE program which creates log files from journals, so
every night we run this program which create log files of who updated what,
this works very well,
This program goes by date and time, so i get the last record from log file
and this this as start date and time in DSPJRN command,

I was just curious to see if i can get the journal records filtered by some
column value along with date and time

i will read this SQL to interrogate journal and see

Thanks for all the suggestions

Ashish

On Fri, May 6, 2011 at 10:02 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:

> Hi,
>
> please read the following blog:
> Using SQL to Interrogate Journal Objects
> http://ibmsystemsmag.blogs.com/i_can/2010/11/index.html
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Ashish Kulkarni
> Gesendet: Thursday, 05. May 2011 18:42
> An: Midrange Systems Technical Discussion
> Betreff: Help with DSPJRN command
>
> Hi
> I wanted to know is there a way to filter records when creating journal
> entries,
> For example, i have a table called PERSON, with 4 columns, NAME, LASTNAME,
> ID, DOB
>
> When using command DSPJRN to journal entries, can i say populate journal
> entries where NAME = 'John'
>
> The reason i want this is because this table is populated or changed very
> often and if i run DSPJRN it takes a long time to build as it has lots of
> records
>
>
>
> --
> Ashish
> www.ayurwellness.com
> www.mysoftwareneeds.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.