INDEX OF TABLE

  • juli13
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
12 years 3 months ago #12414 by juli13
INDEX OF TABLE was created by juli13
Hello,

I would like to ask if there is any globus or jbase table which keeps all indexes for all tables.
For example I made below indexes.
1. CREATE-INDEX FBNK.STMT.ENTRY BOOKING.DATE
1. CREATE-INDEX FBNK.FUNDS.TRANSFER PROCESSING.DATE

After that I execute the command
1. LIST-INDEX FBNK.STMT.ENTRY --> take the indexes of the FBNK.STMT.ENTRY table
2. LIST-INDEX FBNK.FUNDS.TRANSFER --> take the indexes of the FUNDS.TRANSFER table

Do you known if exists any table that keeps all relevant information for all indexes for all table???

Thank you

Please Log in or Create an account to join the conversation.

More
12 years 3 months ago #12415 by jpb
Replied by jpb on topic INDEX OF TABLE
The indexes are stored individually in a ]I file for each table they are created for, in your example
e.g.
../bnk.data/ac/FBNK_STMT_ENTRY]I
../bnk.data/ac/FBNK_FUNDS_TRANSFER]I

So you can write a routine to scan for all ]I files, get the name of the table and do an LIST-INDEX capturing the result.

There is no utility doing it for you.

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds