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.