At 09:24 AM 7/8/98 -0700, Valeda Franklin wrote:
>I have been following the discussion on RECNO and hate to sound like a dummy,
>but what the heck is 'HWMPUT'??  I've even checked our manuals and can't find
>anything.
>TIA

HWMPUT is an option whereby DBPUTs of new entries to a detail set raise the
high-water mark and insert the new entry at the end of the set.  When the
HWM reaches the set's capacity, then the delete chain is used when adding
new entries until the set become full.  This is opposite of the normal
processing whereby DBPUTs of new entries utilize the delete chain to obtain
an empty slot in the set and when the delete chain is empty, then push the
HWM to add the entry to the end of the set.

There are lots of situations whereby this is useful.  Obviously a faster
batch-update is one option.  There also has been other discussion about using
this feature to do an 'on-line reorganization'.  However, in literially all
cases, if the set is dynamic and entries are removed it still is necessary to
conduct a full-blown reorganization at some point simply for overall
performance reasons.

I believe this is documented on the CD-ROM and also in the August'97
version of
the IMAGE/SQL manual, but I haven't gone looking to confirm.




/jf
                              _\\///_
                             (' o-o ')
___________________________ooOo_( )_OOoo____________________________________

                          Tuesday, July 7th

           Today in 1898 - The U.S. annexed Hawaii (and I thought
                           (Houston's annexation powers were too
                            broad!)

___________________________________Oooo_____________________________________
                            oooO  (    )
                           (    )  )  /
                            \  (   (_/
                             \_)