At 04:30 PM 10/20/97 -0700, Tracy Johnson wrote:
>I've been given a task of updating a field in a database, all occurences
>of this field is a search or a sort key.  It has been awhile since I've
>had to do this kind of problem.  (I also haven't heard any hullaballoo
>about "when are we going to get CIUpdate" in a few years, so I suppose HP
>finally implemented it.)

Wirt Atmar and myself went to beautiful Sun Valley,  Idaho and spent a
number of days at Adager's lab both BETA testing CIUPDATE as well as
characterizing its performance.  It was subsequently released by HP
in 1992.


>What are the preconditions for CIU to work?

You should understand whether the application relies on calls to
DBUPDATE failing when attempting to update a search or sort field.
If indeed the this is an expected behavior, then you should set
CIUPDATE to 'ALLOWED', which means by default CIUPDATE is not allowed,
but can be enabled for the specific task by calling DBCONTROL, mode 5.
And conversely disabled using DBCONTROL mode 6.

>What do I do to get it started in DBUTIL?

In DBUTIL:

   SET basename/maintword CIUPDATE={OFF
                                    ALLOWED
                                    ON}


>Does it work from Query?

Yes, but only if the setting for the database is CIUPDATE=ON.
Unfortunately QUERY does not provide the ability to issue DBCONTROL
options to an opened base.... :(

>If so, is there a special command, or does Query's "UPDATE REPLACE"
>command take care of it by itself.

No special commands needed, simply set CIUPDATE=ON and the existing
change/update commands in QUERY will work.

>Sorry for the ignorance but, from 1994 to February of this year, I only
>had to worry about NM KSAM files.  If CIUpdate ever got implemented, it
>flew by me.

Given CIUPDATE was released in '92, you've lost 2 other years.... ;-)


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


     On this day, in 1879 - Thomas Edison first successfully demonstrated
                            his incandescent light.

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