title: setting up a default value of a column in select statement
body: <p>actually i have 2 tables table1 and table2</p>
  
  <p>table1</p>
  
  <pre><code>name
  city
  addr.
  </code></pre>
  
  <p>table2</p>
  
  <pre><code>name
  city
  addr.
  ph.no
  </code></pre>
  
  <p>now ph.no field is an extra field in table 2</p>
  
  <p>so i want to show field ph.no with a default value of 12345 in the output of select query on table1 as i want to append that output into an outfile.
  help me out ..I am using db2 as400 database  </p>