Trying to add index to Hashed file

shin0066 · Post by **shin0066** » Mon Dec 17, 2007 8:23 am

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!

chulett · Post by **chulett** » Mon Dec 17, 2007 8:33 am

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.

shin0066 · Post by **shin0066** » Mon Dec 17, 2007 9:59 am

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.

shin0066 · Post by **shin0066** » Mon Dec 17, 2007 10:00 am

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.

chulett · Post by **chulett** » Mon Dec 17, 2007 10:02 am

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?

shin0066 · Post by **shin0066** » Mon Dec 17, 2007 11:15 am

Ii verified the COL1 - is on hashed file columns and with same case (upper case)

ArndW · Post by **ArndW** » Mon Dec 17, 2007 11:34 am

Do a "LIST DICT <yourfilename>" and tell us the output.