DBC.tvFields.CompressValue does not exist

Database
Enthusiast

DBC.tvFields.CompressValue does not exist

Hello Friends,

I did a restore from Td12 to my TD-14 on VMWare. When I double-click on a table to list the columns inside, I am getting an error:- "Column/Parameter DBC.tvFields.CompressValue does not exist." I tried looking up online, but, no use.

When I see the definition for table DBC.tvfields, this column does not exist in the definition. 

Also, when I run a query on dbc.columns, I get the same error message. When I read about the changes between td-12 and td-14, I came to know that tvfields.compressvalue is removed. How do we overcome this situation?

Do you have any round-about for this one?

Thanks,

SS

Tags (2)
2 REPLIES
Junior Contributor

Re: DBC.tvFields.CompressValue does not exist

Which client do you use to "double-click"?

It seems to directly access the base tables (which is strongly not recommended) instead of the views. 

Regarding dbc.Colums it's strabge, because this column is still included, it's just NULL.

Enthusiast

Re: DBC.tvFields.CompressValue does not exist

Thanks Dieter. I used TD- Admin. Yes, the field returns NULL now. 

While the restore was happening, I did not do a DIPALL. That must have been the culprit. :(

Thanks,

SS