title: Definition of a view in DB2
body: <p>Is there any query/SQL Statement to see definition of a <code>view</code> in <code>DB2</code>?</p>
  
  <p>I tried the following and it is resulting in an error as shown below</p>
  
  <pre><code>  SELECT * FROM SYSCAT.VIEWS
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/seRT9.jpg" alt="enter image description here"></p>
  
  <p><strong>REFERENCE</strong>:</p>
  
  <ol>
  <li><a href="https://stackoverflow.com/questions/2341072/show-create-view-definition">show create view definition</a></li>
  <li><a href="https://stackoverflow.com/questions/2973186/how-to-view-db2-table-structure">How to view DB2 Table structure</a></li>
  </ol>
  
  <p><strong>VERSION</strong>:</p>
  
  <p>Test results based on <a href="https://stackoverflow.com/questions/3821795/how-to-check-db2-version">How to check db2 version</a> are listed below (for version)</p>
  
  <p><img src="https://i.stack.imgur.com/A0WAI.gif" alt="enter image description here"></p>
  
  <hr>