How to query Invalid Views

Posted in 2012

PRADEEP KUMAR — Mon, 01 Oct 2012 09:51:05 — source: IIUG Forums & Mailing Lists

I want to know name of all views in my database which are actually invalid views ( base table's column is dropped ) and are going to throw -217 error when application try to access those. Any SQL to query system table to list such views..? Thanks, Pradeep

Related threads

How to get the sequence value in ESQL/C program?