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.
>