JBASE INDEX
- Andi
- Topic Author
- Offline
- New Member
Less
More
- Posts: 9
- Thank you received: 0
8 years 9 months ago #17579
by Andi
JBASE INDEX was created by Andi
dear all
my goal is to create an index in jbase from FBNK.CR.CONTACT.LOG file and the colums to be indexed are @ID and CONTACT.CLIENT
and i have done the following steps
1 i create index with the name TEST by the following command
jsh t24test ~ -->CREATE-INDEX -m FBNK.CR.CONTACT.LOG TEST BY @ID : CONTACT.CLIENT : CONTACT.DESC
Notice: Command converted to 'CREATE-INDEX -m FBNK.CR.CONTACT.LOG TEST BY-AL 0 : 1 : 4'
Index definition 'TEST' created successfully
2 i rebuild the index by the following command
jsh t24test ~ -->rebuild-index FBNK.CR.CONTACT.LOG TEST
3 i list the index with the following comand
jsh t24test ~ -->LIST-INDEX FBNK.CR.CONTACT.LOG
displays the following out put
INDEX definitions for file FBNK.CR.CONTACT.LOG at 09:34:56 03 JUN 2015 PAGE 1
INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION...................
TEST en_US AL BY-AL 0 : 1 : 4
1 Records Listed
jsh t24test ~ -->
my expectation was displaying the @ID and CONTACT.LIST as a filed from TEST(the index which have created) and within the corresponding columns(fields ).
how could i achieve these goals? and what's wrong with my steps?
thank you
my goal is to create an index in jbase from FBNK.CR.CONTACT.LOG file and the colums to be indexed are @ID and CONTACT.CLIENT
and i have done the following steps
1 i create index with the name TEST by the following command
jsh t24test ~ -->CREATE-INDEX -m FBNK.CR.CONTACT.LOG TEST BY @ID : CONTACT.CLIENT : CONTACT.DESC
Notice: Command converted to 'CREATE-INDEX -m FBNK.CR.CONTACT.LOG TEST BY-AL 0 : 1 : 4'
Index definition 'TEST' created successfully
2 i rebuild the index by the following command
jsh t24test ~ -->rebuild-index FBNK.CR.CONTACT.LOG TEST
3 i list the index with the following comand
jsh t24test ~ -->LIST-INDEX FBNK.CR.CONTACT.LOG
displays the following out put
INDEX definitions for file FBNK.CR.CONTACT.LOG at 09:34:56 03 JUN 2015 PAGE 1
INDEX NAME LOCALE NAME SORT KEYS. LOOKUP.... INDEX DEFINITION...................
TEST en_US AL BY-AL 0 : 1 : 4
1 Records Listed
jsh t24test ~ -->
my expectation was displaying the @ID and CONTACT.LIST as a filed from TEST(the index which have created) and within the corresponding columns(fields ).
how could i achieve these goals? and what's wrong with my steps?
thank you
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
8 years 9 months ago #17581
by jpb
Replied by jpb on topic JBASE INDEX
try with
verify-index -rv FBNK.CR.CONTACT.LOG TEST
verify-index -rv FBNK.CR.CONTACT.LOG TEST
Please Log in or Create an account to join the conversation.
Time to create page: 0.092 seconds