Dot,

A bit of a "plug", but relating to your question.  We work exclusively on
the HP 3000 platform and have developed Time Shift 2000 for data analysis
and aging…

G.R. Helm, Inc. specializes in Year 2000 services and the HP 3000.  We have
been supplying services to the HP community since 1988.  We provide
outsourcing services using in-house systems including our HP3000 system and
a standardized approach to software Year 2000 compliance practices.  GRHI
has developed, and continues to develop, tools to assist in the analysis and
testing phases of these projects.

Time Shift 2000™ is one of the first tools developed at GRHI.  It will both
'analyze' and 'age' date data fields in an IMAGE database.  This software
has been designed to automatically find and examine all date fields
contained in a database, with no user input or directions.  (However, user
inputs can be used to refine the search process.)  The software determines
the date format and the range of date values contained within each data
set's date field.  It also reports the number of records found for each year
encountered, the number of any unknown date values and the location of the
date field within the field (when date fields are concatenated within other
fields).

Time Shift 2000™'s 'aging' feature allows the user to increment any of the
IMAGE date fields by some number of years (positive or negative). TS2000
process dates by their IMAGE field name but also allows the user to exclude
fields from particular sets.  Therefore, if field 'TEMP-HOLD' contains a
date in one data set, but not in another, TS2000 can be directed to only
update the field in the data set containing the dates.  This aging process
becomes very useful in testing to verify processing results that should not
be affected by time changes.  (In other words, the results of a base-line
test using today's date and data should match the results of a test with the
data 'aged' forward by some number of years - assuming day of week and leap
year validations are not performed - and the system clock set forward by
this same number of years.) This type of age testing can be performed
incrementally until all the data has been aged into the 21st century to
verify the functionality of applications as they encounter year 2000 dates.

Note: Time Shift 2000 is also being enhanced to age KSAM files and Flat
files.  This should be available sometime in November.

Please visit our web site at http://www.grhelm.com/year2000 or contact us at
(888) 665-9065 or at (916) 933-9669 for additional information or email us
at [log in to unmask]  We also have demonstration copies of Time Shift
2000 available.


Regards,
Gordon Helm
----------------------------------------------------------------------------
----
==============================================
G. R. Helm Information Srvcs, Inc.       Year 2000 Consulting
4993 Golden Foothill Pkwy, Suite 8       HP 3000 Specialists
El Dorado Hills, CA  95762                            (888) 665-9065
[log in to unmask]                         www.grhelm.com
Designers of TimeShift 2000™              Date Analysis/Aging
----------------------------------------------------------------------------
----


Time Shift 2000 Features
Analysis:
1.      Automatically locates all databases and determines the date fields
residing in these databases.
2.      Allows user to refine the searching capability used to locate the date
fields in the database.
3.      Analyzes for both numeric and non-numeric data, including I2, I4, J2, J4,
P4, P8, Pn, Xn, Zn.
4.      Reports occurrences of MY, YM, MDY, M*D*Y, YMD, Y*M*D, DMY & D*M*Y
formatted dates.
4.1     Tallies the years encountered within a date field.
4.2     Tallies the "Unknown" date formats within a date field.
4.3.    Tallies occurrences of special conditions:
4.3.1.  Blank or empty date fields
4.3.2.  Date fields containing "999999"
4.3.3.  Date fields containing "000000".
4.4     Tallies the occurrences for each within a database.
4.5     Tallies the occurrences for each within the scope of the report.
4.6     Determines the index of a date entry within an array.
4.7     Determines the offset of the date field if contained within a field or
array entry.
4.8     Identifies the high and low values of the date field.
5.      Automatically builds exclusion records for arrays fields.
6.      Pre-loads the TSDATES file with all item definition information for the
aging process.
7.      Permits the user intervention to improve the accuracy of the report.
7.1     Edit option available for the date format.
7.2     Edit options available for the data field offset and index.
7.2.1.  Can address multiple array entries via the data field index.
7.2.2.  Can specify where the date starts within a field.
7.3     Edit options available to add, delete or exclude data sets or date
fields.
7.4     Search criteria [date strings from the parameter file] can be broadened
in prior to the evaluation of data.
7.5     Exceptions to the search criteria can be added after the analysis has
already run.
8.      Can be run multiple times against the user modified TSDATES file,
allowing refinement of the reported information.
Time Shift 2000 Features
Aging:
1.      Can age 16 different formats of date data, including dates with century
information.
2.      Ages both numeric and non-numeric data, including I2, I4, J2, J4, P4, P8,
Pn, Xn, Zn.
3       Ages date entry indicated by the index of an array.
4.      Ages date relative to the offset of the date field within the data item
or item's array entry.
5.      Ages test data dates by year or days increments.
6.      Ages sort items dates.
7.      Ages search dates in detail sets.
8.      Ages key items in manual master data sets.
9.      Retains the sign on numeric date data.
10.     Reports occurrences of the format provided in the TSDATES file.
10.1    Tallies the years generated by aging a date field.
10.2    Tallies the "Unknown" date formats within a date field.
10.3.   Tallies occurrences of special conditions:
10.3.1. Blank or empty date fields
10.3.2. Date fields containing "999999"
10.3.3. Date fields containing "000000".
10.4    Tallies the occurrences for each within a database.
10.5    Tallies the occurrences for each within the scope of the report.
10.6    Identifies the high and low values of the date field as a result of
aging.




Date:    Tue, 22 Sep 1998 17:25:48 -0400
From:    [log in to unmask]
Subject: Y2K

Is there some good software that will run on the HP3000 to analyze source
code for dates or date-related patterns?  How about analyzing the data in
databases?  We are trying to determine our exposure to Y2K problems and
would love to find the right software to make the task easier.  If you have
found any that you would recommend, please let me know -- I would greatly
appreciate it.  My email address is [log in to unmask]  Thanks.