Re: Record was Change

I agree with Alan.You have to design database in such way that you do not
need to depend upon system's value
or journaling.

Thanks & Regards
Mahesh Pawar
Project Manager,

Systems & Software,
SDF IV,Unit # 123,Seepz,
Andheri(W)-400 096,Mumbai, India
Phone# 0091-22-28290075,28291824
Website: www.systsoft.com

----- Original Message -----
From: "Alan E." <steelville@xxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, July 25, 2003 8:34 AM
Subject: Re: Record was Change


> This is also why I've been in the habit of setting up a "job
> stamp" for records in new files. Job name, job number, user
> profile, time written. Both at create and change steps.
>
> One cannot journal the whole universe, anyway. Zap the
> journal, you still have "who did it". Actually this was
> **very** useful in one security instance.
>
> - Alan
>
>
> ----- Original Message -----
> From: "Paramasivam Murugesan , Gurgaon"
> <ParamasivamM@xxxxxxxxxxxxxxx>
> To: "RPG programming on the AS400 / iSeries"
> <rpg400-l@xxxxxxxxxxxx>
> Sent: Thursday, July 24, 2003 2:19 AM
> Subject: RE: Record was Change
>
>
> | Alex,
> | Unless you have a time or timestamp field in your file,
> there is little way
> | to find that out.
> | However, you can find when the file object was changed.
> |
> | If you do journalling the physical file, you can get it
> from the Journal
> | entries. Hope that will suffice.
> |
> | Thanks
> | Murugesh
> |
> | -----Original Message-----
> | From: Rizo, Alex L. (RPW)
> [mailto:ALRizo@xxxxxxxxxxxxxxxxxx]
> | Sent: Thursday, July 24, 2003 3:40 AM
> | To: rpg400-l@xxxxxxxxxxxx
> | Subject: Record was Change
> |
> |
> | Is their a way to tell when a record was changed.
> |
> |
> | Thanks Alex
> | _______________________________________________
> | This is the RPG programming on the AS400 / iSeries
> (RPG400-L) mailing list
> | To post a message email: RPG400-L@xxxxxxxxxxxx
> | To subscribe, unsubscribe, or change list options,
> | visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> | or email: RPG400-L-request@xxxxxxxxxxxx
> | Before posting, please take a moment to review the
> archives
> | at http://archive.midrange.com/rpg400-l.
> | _______________________________________________
> | This is the RPG programming on the AS400 / iSeries
> (RPG400-L) mailing list
> | To post a message email: RPG400-L@xxxxxxxxxxxx
> | To subscribe, unsubscribe, or change list options,
> | visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> | or email: RPG400-L-request@xxxxxxxxxxxx
> | Before posting, please take a moment to review the
> archives
> | at http://archive.midrange.com/rpg400-l.
> |
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--------------------------------------------------------------
Systems & Software, Mumbai, India
 Sent using PostMaster by QuantumLink Communications Pvt Ltd
 One Internet account, unlimited personal e-mail addresses
 Get your free copy of PostMaster at http://www.postmaster.co.in/