title: How to revalidate specific views in Db2
body: <p>I need to revalidate all invalid views in a database.
  IBM writes on their website, that you can achieve this with </p>
  
  <pre><code>CALL ADMIN_REVALIDATE_DB_OBJECTS ('view',NULL, NULL );
  </code></pre>
  
  <p>but that would revalidate all my views, but I only need to revalidate the invalid ones.<BR>
  I think you could get invalid views with</p>
  
  <pre><code>SELECT VIEWNAME FROM SASCAT.VIEWS WHERE VALID='N'
  </code></pre>
  
  <p>Anyways... I don't know how to solve my problem with this Information, I tried out a few things, but I can't find the answer.</p>