title: Birt/Set Schema and Set Path
body: <p>I'm currently using a schema that will be changed to another schema in a couple of months. I do not not want to have to remove the SCHEMA_NAME multiple times from each report. All the reports so far have this format:</p>
  
  <pre><code>SELECT
      COLUMN_NAME1,
      SCHEMA_NAME.USER_DEFINED_FUNCTION(COLUMN_NAME2),
      COLUMN_NAME3
  FROM
  SCHEMA_NAME.TABLE_NAME
  </code></pre>
  
  <p>I want to remove the schema name from the query so it looks like this: </p>
  
  <pre><code>SET SCHEMA LROUIM;
  SET PATH LROUIM;
  SELECT
      COLUMN_NAME1,
      USER_DEFINED_FUNCTION(COLUMN_NAME2),
      COLUMN_NAME3
  FROM
  TABLE_NAME
  </code></pre>
  
  <p>I need the "SET SCHEMA" for the table name and "SET PATH" for the User Defined Function. This code works in Squirrel SQL, but if I insert this code into a Birt data set of type SQL SELECT QUERY, I get an error because of </p>
  
  <pre><code>SET SCHEMA LROUIM;
  SET PATH LROUIM;
  </code></pre>
  
  <p>How do I implement SET SCHEMA and SET PATH in a SQL Select Query in Birt?</p>