Do I need to unload/reload the file?

Witkopp, Richard Richard.Witkopp@idt.com
Fri, 15 Mar 2002 09:54:49 -0800


Well, sorta. Changing the dictionary is only a map
that Powerhouse uses. It doesn't affect that data itself
at all. You'll need to CONVERT the file, which will create
an index on it. Just be careful not to use Powerhouse's
generated .fdl because it results in a very inefficient
file.

> -----Original Message-----
> From: Hoppe, Eric EP [mailto:Eric.Hoppe@steelscape-inc.com]
> Sent: Friday, March 15, 2002 9:19 AM
> To: 'powerh-l@lists.swau.edu'
> Subject: Do I need to unload/reload the file?
> 
> 
> Hi all-
> 
> I am running PH 7.10G1 on OpenVMS 7.1 and have a simple 
> question we have
> been discussing and thought to see what the pros say...
> 
> If an element is changed to be a key, do I need to 
> unload/reload the data?
> I know (of course) what needs to be recompiled.  Historically, when in
> doubt, we have just done the reload.  If we don't need to do 
> the reload, we
> can make the change without taking the system down.  By 
> changing the field
> to a key, we are not affecting the offset of the data which 
> leads me to
> believe we do not need to reload the data.
> 
> To be a bit more illustrative, I want to change 
> cd-suppl-paint to be an
> alternate, repeating, ascending key.
> -- Record Contents --
>     Item                                 Type            Size 
>  Occ  Offset
>     NO-PAINT-REF                         CHARACTER         10 
>            0
>     .CD-GLOSS                            ZONED UNSIGNED     1 
>            0
>     .CD-TY-PAINT                         CHARACTER          2 
>            1
>     .CD-PAINT                            CHARACTER          1 
>            3
>     .NO-PAINT                            ZONED UNSIGNED     5 
>            4
>     .CD-SUPPL-PAINT                      CHARACTER          1 
>            9
> 
> Thanks-
> 
> ---ehops
> 
> Eric Hoppe
> Steelscape, Inc.
> Senior Systems Analyst
> Kalama, WA  USA
> 360.673.8247
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to 
> powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to 
> powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a 
> subscriber.
>