Non-Generated System
Specifically with the Year 2000 problem in mind, improvements have been made to the File Import mechanism to ensure a very high hit rate on detecting fields in the database which are Dates (including Years and Periods).
Previously, the descriptions in the file field definitions were used in conjunction with field sizes to ascertain if a field was a "date" classification during the "CRTDD" command operation (fields of length 6 with the word "date" in the description were given the classification DATE6). There is now a second pass, initiated by Command GVANLYSEDB, that reads the data in the imported files using the record layout which extracted using CRTDD. Any field which is 2 - 8 long without decimal positions is checked to be one of the following Genesis V classifications in more than 90% of the available data.
Click HERE for a list of date classifications
The decisions made by the GVANLYSEDB command can be viewed in or printed from source member ANLSDB in GVTXTSRC in your import environment.
Fixing your non-generated database to hold century portions for each date should take only a few days to complete. This includes auto-creation of conversion programs to set the century portions as 19 or 20 (0 or 1 if you prefer) in your test, then live database. This includes running the conversion programs over multi-member files.
The Genesis V Program Import mechanism can be used to build a full cross reference (where used) element from program to program and file to program.
The Genesis V Source Code Analyser will extract Display files into a Genesis V specification to show the format layouts using option 'V' (view) from the program list (and is useful in the "field where used" display). The Analyser will extract fields used in the RPG code for reference in the "field where used" display.
The analyser will mark lines of code which are vulnerable to the year 2000 problem. The hit rate of the analyser is very high. 90% of programs are marked completely and the remaining 10% have 80% of the vulnerable lines marked for action.
Separate documentation on "how to proceed" is available on request.
CL source can be read to extract the "*ENTRY PLIST" so that the "E" to execute option can be taken from the list of programs.
IBM Query programs can be imported into the list to extract information for the File where-used
An "Overrides" File has been created so that compiles through Genesis V will now perform OVRDBFs before the CRTRPGPGM.
As part of this work, several utilities have been developed which are useful in general non-generated systems house-keeping.
