system
#1
I have create 100+ object that need to change only slightly. I.e
I have a class called ST complete
and each object is like this …
max(decode(SITE_TASKS.WOT_TOS_TAS_CODE,‘01010’,SITE_TASKS.WOT_COMPLETE,NULL))
I now need to copy the 100+ objects and change WOT_COMPLETE TO WOT_PLANNED
Is there a way of doing this by mass or do I have to go through each 100+ record individually and amend manually .
help me BOB fans u r my only hope :’’’-(
Cheers
Sherpa
Sherpa (BOB member since 2003-12-02)
system
#2
Would a database synonym work?
Create a synonym with the old universe object reference that points to your new database object. Assumes you are getting rid of your old object.
But personally I would change all the objects one by one.
Miguel Varela (BOB member since 2002-08-15)
system
#3
If you are in v6 you can try using the “replace” feature under the Edit Menu in Designer
tp_4321 (BOB member since 2003-09-21)
system
#4
Another option is the Designer SDK. This utility updates names / descriptions, but could be modified to do the same for the Select statement.
Dwayne Hoffpauir (BOB member since 2002-09-19)