FIle restructure bastardization
Don Coleman
dcoleman at dgcreact.com
Tue Sep 20 09:18:22 PDT 2005
I have a fP file with 16 qualifiers and a total for 51M records spread
across the qualifiers. This business functions 24/7 and it presents
quite a disruption to have them down for any period of time. Within
this file are two YESNO flag fields which are always either "Y" or left
blank. Rather than attempt to restructure this file which will take
hours (Windows network) can I copy a modified map file (with everyone
out of the system) changing the edit on these two fields from YESNO to
either * or ALLUP? Will the new map preserve the fields containing the
"Y" data? I do realize that this is not the preferred method of
restructuring a file but you can see where I am going. Doing so will
allow me to use various codes in those fields instead of the limitation
of Y,N, blank and not force me to add additional fields.
Don Coleman
More information about the Filepro-list
mailing list