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.





This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].