Re: Output Journal data in Physical file

[Ashish Kulkarni <ashish.kulkarni13@xxxxxxxxx>]

Hi
I downloaded this utility and i was able to create a file from journal data,
it works great, i have couple of questions if you don't mind answering
1, can i modify this utility to fit my requirements?
2, What i need to do is to run this utility interactive then in batch
3, Send date and time to this utility so i can control which journal records
i can copy to file
4, Send type of records, i am only looking for UP (image after records only)

What i am trying to do is satisfy a requirement of getting information of
who updated records in a table and when, so instead of trying to create log
files through triggers or programs create log files from journals and store
them in data warehouse for reporting purpose.


Ashish


On Tue, Mar 30, 2010 at 7:55 AM, <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx> wrote:

> we don't have DBU or TAATOOLS so i wrote my own.  you can download it from
> my website if interested http://tommyholden.com it's in the download
> section under Miscellaneous Save Files and is labelled Get File's Journal
> Entries To Outfile
>
> Thanks,
> Tommy Holden
>
>
>
> From:   "Lennon_s_j@xxxxxxxxxxx" <lennon_s_j@xxxxxxxxxxx>
> To:     midrange-l@xxxxxxxxxxxx
> Date:   03/29/2010 08:33 PM
> Subject:        Re: Output Journal data in Physical file
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> Not sure what you are asking, but you might be interested in the EXPJRNE
> (Export journal entries) command, here:
>
> http://www.tools400.de/English/Freeware/Utilities/utilities.html
>
> It will create a file of the journal transaction for a specified file,
> and the JOESD field will have the names from the original file.
>
> Sam
>
>
> On 3/29/2010 4:30 PM, Ashish Kulkarni wrote:
> > Hi
> > What is the correct way of getting journal data in PF, for example DBU
> > utility DBUJRN gets data in DBUJRNPF file, i would like to do some thing
> > similar
> >
> > Any suggestions
> --
> 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.