For a complete picture the SELECT statement should also be performed on the Fxxx.CUSTOMER$NAU file to pick up unauthorised changes and the Fxxx.CUSTOMER$HIS file to pick up any sequence of changes. Reversals are not allowed for the CUSTOMER file, but for a similar problem with other applications their possibility would have to be considered also.
If you are concerned that local code may contain direct writes into the CUSTOMER files then I suggest you examine the operating system timestamps for Fxxx.CUSTOMER, Fxxx.CUSTOMER$NAU and Fxxx.CUSTOMER$HIS. Philip Knight T24 Technical Consultant On Aug 23, 10:56 pm, JOSE L MARTINEZ-AVIAL <[email protected]> wrote: > SELECT FBNK.CUSTOMER WITH DATE.TIME GT 1001080000 > > that gives you all the records in customer tAble modified after > January 8th 12:00 AM. > 2010/8/23, Lior-TIS <[email protected]>: > > > > > Hello, > > > What is the best & most reliable way to find out what records have > > been changed in a specific table since a specific date? > > For example, all the records that have been added / changed in > > CUSTOMER table since 1/8/2010. > > > -- > > Please read the posting guidelines at: > >http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > IMPORTANT: Type T24: at the start of the subject line for questions specific > > to Globus/T24 > > > To post, send email to [email protected] > > To unsubscribe, send email to [email protected] > > For more options, visit this group at > >http://groups.google.com/group/jBASE?hl=en- Hide quoted text - > > - Show quoted text - -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
