Programmatically disable an index

[D.Cook]

Say I wanted to load some data into a database table and I knew the procedure was in single-user mode, is it possible to programmatically disable an index? And then rebuild it?

 

[TomBascom]

Disabling it is fairly easy... you just fiddle the appropriate _Index fields.

Rebuilding it requires the use of proutil so if "programmatically" means "with 4gl" the answer is "no".

 

[D.Cook]

Thanks Tom

 

[KrisM]

Strange that proutil has a IDXACTIVATE qualifier, but not a IDXDEACTIVATE qualifier.

 

[D.Cook]

Especially considering an enhancement request was logged in 2004..
P74611