Page 1 of 1

Trying to add index to Hashed file

Posted: Mon Dec 17, 2007 8:23 am
by shin0066
hi,
I am trying to add a Index via Admin GUI as below
CREATE.INDEX <filename with Path> COL1

it throwing "<filename with Path> is not a file name"

Any idea, why it is not taking the path and file name, am i missing anything before creating an Index on Hashed file?

Any info is appreciated!

Posted: Mon Dec 17, 2007 8:33 am
by chulett
It doesn't want the full path to a hashed file, it wants the VOC name. Which means you either need to create an 'Account' based hashed file or, after creating a pathed one in a directory, create a VOC entry for it as well.

I don't have it handy, but I'm sure that if you searched for your CREATE.INDEX syntax in the forums, all of that would be detailed out.

Posted: Mon Dec 17, 2007 9:59 am
by shin0066
Thanks Chulett,

i created a VOC entry for the hashed file and it was successful but when i tried to crate index
CREATE.INDEX <hashedfilename> <COL1>
it throws out error message as below - any thoughts?

Code: Select all

Cannot find field name COL1 in file dictionary or VOC, no index created.

Posted: Mon Dec 17, 2007 10:00 am
by shin0066
Thanks Chulett,

i created a VOC entry for the hashed file and it was successful but when i tried to crate index
CREATE.INDEX <hashedfilename> <COL1>
it throws out error message as below - any thoughts?

Code: Select all

Cannot find field name COL1 in file dictionary or VOC, no index created.

Posted: Mon Dec 17, 2007 10:02 am
by chulett
Nothing other than the obvious - that you don't have a column in your hashed file with the name you used in the CREATE.INDEX statement. You sure it was spelled correctly, case and all?

Posted: Mon Dec 17, 2007 11:15 am
by shin0066
Ii verified the COL1 - is on hashed file columns and with same case (upper case)

Posted: Mon Dec 17, 2007 11:34 am
by ArndW
Do a "LIST DICT <yourfilename>" and tell us the output.