Skip to main content
Question

UNIDATA -- create a list of all indexes on all files

  • December 1, 2022
  • 5 replies
  • 1 view

Rick Brown
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick

5 replies

John Jenkins
Forum|alt.badge.img+1
  • Participating Frequently
  • December 1, 2022
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick
Would COMO ON <name> help here?

Regards

JJ

Manu Fernandes
Forum|alt.badge.img+2
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick
hi Rick,

I share a little prog 'uv' basic, you can easily adapt to udt 'basic' .
I use it to look at all indices and prepare a 'backup' of CREATE.INDEX ... all file 

I hope this help
Manu

Manu Fernandes
Forum|alt.badge.img+2
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick
The prog

KathleenHambrick
  • Participating Frequently
  • December 2, 2022
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick
Yup - as most here have shown, this would be a utility program I write at every place I work. I do one for triggers as well, similar concept. 

Best,
Kathleen

Rick Brown
  • Author
  • Participating Frequently
  • December 2, 2022
Hi All,

Is there a way from ECL to generate a list of all indexes on all files? (And the index attributes)

I know I can do a LIST.INDEX FN at the ECL prompt file by file, and I could script running through all VOC records that are files, but I cant seem to pipe and append this ouput to a text file.

Rick
Thank you everyone!