Hello,
I need to add a new field and index to an existing table
Database is multi-user.
Table: Image
Field List: ImageID, Name
Index: Image_Idx (Primary, active, unique) Field: ImageID
I need to add:
New Field: NewImageID
New Index: NewImage_Idx (Active, Unique) Field: NewImageID
I created an incremental df to be applied programmatically.
.
.
.
ADD FIELD "NewImageID" ....
ADD INDEX "NewImage_Idx" ON "Image"
AREA "Schema Area"
PRIMARY
UNIQUE
INACTIVE
INDEX-FIELD "NewImageID" ASCENDING
Once I load the .df, I'd like to activate the new index "NewImage_Idx" by using PROUTIL IDXBUILD but it won't work because the db is multi-user. I'll appreciate your help.
Thank you.
I need to add a new field and index to an existing table
Database is multi-user.
Table: Image
Field List: ImageID, Name
Index: Image_Idx (Primary, active, unique) Field: ImageID
I need to add:
New Field: NewImageID
New Index: NewImage_Idx (Active, Unique) Field: NewImageID
I created an incremental df to be applied programmatically.
.
.
.
ADD FIELD "NewImageID" ....
ADD INDEX "NewImage_Idx" ON "Image"
AREA "Schema Area"
PRIMARY
UNIQUE
INACTIVE
INDEX-FIELD "NewImageID" ASCENDING
Once I load the .df, I'd like to activate the new index "NewImage_Idx" by using PROUTIL IDXBUILD but it won't work because the db is multi-user. I'll appreciate your help.
Thank you.