Page 1 of 1

problem with look up

Posted: Sun May 07, 2006 6:30 am
by deeps
Hi,
I tried renaming a column in a lookfile set .... When this new look up is reused, I get the error that : "Cannot read old version of contiguous lookup table".
Tried dropping the lookup, clearing the scratch area and recreating it ... but doesnt work :-(

Posted: Sun May 07, 2006 9:46 am
by kumar_s
What happenes, if you give new path or new file name for the renamed file?

Posted: Sun May 07, 2006 2:26 pm
by ray.wurlod
File Sets are not stored in the scratchdisk area, they are stored in the disk area. You need to clean up the control file (blah.fs) as well as the data files on each partition.

Posted: Mon May 08, 2006 6:04 am
by kumar_s
Just try to rename the column and execute once and try to view the fileset contol file from unix prompt just by cat fileset.fs, and make sure the renamed column is getting reflected in the control file.