SQL0575N db2查询视图报错

来源:互联网 发布:卫生防疫厨房监控软件 编辑:程序博客网 时间:2024/05/19 14:50

select * from viewname
做查询的时候报错

SQL0575N  View or materialized query table "DB2INST1.LATEFEEVIEW" cannot be used because it has been marked inoperative.  SQLSTATE=51024

通过查询syscat.tables确认,哪些视图是无效的状态

select tabschema||tabname from syscat.tables where TYPE = 'V' and    STATUS='X'

重建查询出来的视图

0 0