INDEX OF TABLE
- juli13
- Topic Author
- Offline
- Senior Member
Less
More
- Posts: 49
- Thank you received: 0
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
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.
- jpb
- Offline
- Moderator
- retired
Less
More
- Posts: 2859
- Thank you received: 649
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.
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