Append FOR READ ONLY after the end of a query statement

Note:  This option is only available for the DB2 database.

Use the steps here to append FOR READ ONLY after the end of a query statement.

Note: This is a global setting that applies to all DB2 source objects. When an object has a user-defined After End of Query Statement code, DWD will override the global setting and use the object level code instead.
  1. On the DWD Designer, select the Data Sources tab.
  2. Right-click the data source you want to modify and select Properties.
  3. On the System Properties window, select the data source connection from the Extract from Data source drop-down field.
  4. Click the Edit Properties button in the drop-down field.
  5. On the System Connections Properties window, select FOR READ ONLY. This option is only available for DB2.
  6. Click Update
  7. Click OK to close the System Connections window. to save the changes. When prompted, click to confirm the changes.
  8. Click OK to close the System Properties window.
  9. Compile the objects under the data source.