JBASE INDEX

More
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

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

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
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

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

Time to create page: 0.092 seconds