sevior
asked on
How to drop invalid views in DB2?
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.
Thank you
-
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.
Thank you
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.