How to drop invalid views in DB2?
Posted on 2014-01-13
Can anyone assist with situation when DB2 view has "valid=N", so after issue 'drop' command?
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0204N "My_view.Name" is an undefined name. SQLSTATE=42704.
Looking for the way that doesn't require recreate parent to this table.