problem with look up

deeps · Post by **deeps** » Sun May 07, 2006 6:30 am

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 :-(

kumar_s · Post by **kumar_s** » Sun May 07, 2006 9:46 am

What happenes, if you give new path or new file name for the renamed file?

ray.wurlod · Post by **ray.wurlod** » Sun May 07, 2006 2:26 pm

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.

kumar_s · Post by **kumar_s** » Mon May 08, 2006 6:04 am

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.