title: Using Unqualified SQL across multiple schemas in DB2 Express C
body: <p>I'm trying to recreate part of the staging and production servers which run under IBM iSeries midrange servers on a local development server. My intended plan is to allow the SQL queries to work seamlessly with DB2 Express C installed on Linux. I got as far as installing PHP, the ibm_db2 PHP extension, and DB2 Express C. Everything works. </p>
  
  <p>My next step is figuring out how to run unqualified SQL statements without specifying the schema. For instance on IBM iSeries, I can specify the i5_libl option with all of my schemas and then I don't have to worry about using fully qualified SQL. But I'm using Linux so the i5_libl option isn't available. </p>
  
  <p>I looked at the DB2 SQL documentation for <code>SET PATH</code> and that's sorta what I want where I could specify multiple schemas, but my understanding is that it only works with <code>CREATE</code>, not static and dynamic SQL which is really all I care about. I also looked into <code>SET SCHEMA</code> and <code>SET CURRENT PACKAGESET</code>, but those only seem to allow only one schema.</p>
  
  <p>For example:</p>
  
  <p>I'll have table <code>SCHEMA1.ABC</code> and <code>SCHEMA2.DEF</code>.</p>
  
  <p>I want to set it up so that I can just run the following from my application:</p>
  
  <pre><code>SELECT * FROM ABC
  
  SELECT * FROM DEF
  </code></pre>