question: Windowing: PF & LF Windowing with Keys

[Glenn Ericson <Glenn-Ericson@xxxxxxxxxxxxxxxxxxxxxxxxxxx>]

You wrote::
>
>I am currently working with a large client in the planning stages of their
>Year 2000 conversion. The enviroment is very complex due to a high degree
>of database interrelations across applications and even AS/400s.
>
>Windowing (at least partially) seems to be approach that they are leaning
>towards here. The major problem with windowing seems to be the issue of
>current physical and logical files which have a date field in the key. Does
>anybody have any experience in dealing with the file sorting problem by non
>expansion of the database? I saw some documentation by IBM regarding an
>approach which uses an ALTSEQ keyword in the file to change the sort order.
>Does anyone have real life experience with this?
>
>Any input would be greatly appreciated.
>
>
>Phil Rocheteau
>TQM inc
>
=============
I would think that  expansion of  Key/index fields would be the  best
payback for many  reasons of sequencing retrieval.  Now once you start
that consider the full  set of applications all files and the impact to
recreate the files.  All should be relatively well as long as your
selected tools handle all that  to minimize the error rate and
implementation rate. And this can be  either phased or  implenemted  during
the available  window

Glenn
___________________________________________________
Glenn Ericson,          Phoenix Consulting                      
P O Box 701164   East Elmhurst NY 11370-3164 USA                            
Ph. 718 898 9805         Fx. 718 446 1150
AS/400 & Year 2000- - Solutions  © 1997copyright,  all rights reserved
____________________________________________________


 
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *