Do I need to unload/reload the file?

[Miller, Daniel]

Forgot to say i assuming RMS files, dont know about rdb etc.

Hi,

AFAIK you do need to reload the data, otherwise it will not be included on
the index; only new data would be.  

I think you would also need to recompile any programs which add records to
the file, otherwise they add records with no index value for the new index.


Daniel Miller
Nightfreight

-----Original Message-----
From: Hoppe, Eric EP [mailto:Eric.Hoppe@steelscape-inc.com]
Sent: Friday, March 15, 2002 5:19 PM
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.