RE: Year 2000 - code scanning ???

Here I can mention some patterns (search terms) to scan informix code. But it is advisable to include patterns derived from dbschema of total database to this list. Some patterns are date, year, yr, yy, today, time, clock, dt and week. By manually looking at the dbschema of database , we can know how the date related fields are coded. Most of the potential problems comes when arithmatic calculations or comparisions have been done on date related varibles declared other than 'date' datatype. > ---------- > From: FreyaIncledon[SMTP:freya.incledon@capgemini.co.uk] > Reply To: FreyaIncledon > Sent: Tuesday, August 18, 1998 11:18 AM > To: informix-list@iiug.org > Subject: Year 2000 - code scanning ??? > > Does anybody have a list of generic search terms with which to scan > informix code for potential Year 2000 problems? I am thinking about > finding non-standard manipulations of dates and other potential problems > that may not be picked up by scanning for the very obvious terms such as > 'dd/mm/yy' etc. > > Freya Incledon >