>Hi,
>
>When using insert command to add record in table its not updating index file. I am not opening table before passing insert command. Is any way to update index file with inser command?
>
>TIA,
Use structural compound index. It's open automaticaly any time a table is open. There's how it can be created.
USE mytable EXCLUSIVE
INDEX ON filed1 TAG filed1 ADDITIVE
INDEX ON filed2 TAG filed2 ADDITIVE
INDEX ON filed3+filed4 TAG f3_f4 ADDITIVE
--sb--