Forum
Keyword

JBASE INDEX

  • Posts: 9
  • Thank you received: 0

Andi created the topic: JBASE INDEX

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
#17579

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

  • Posts: 2836
  • Karma: 509
  • Thank you received: 637

jpb replied the topic: JBASE INDEX

try with

verify-index -rv FBNK.CR.CONTACT.LOG TEST

Some people feel the rain - others just get wet (Bob Marley)
#17581

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

Time to create page: 0.114 seconds