SAP Knowledge Base Article - Public

1730922 - How to access the DB2 database with "Uncommitted Reads" (dirty reads) in Crystal Reports 2008.


How to access the DB2 database with "Uncommitted Reads" (dirty reads).


  • Crystal Reports 2008
  • Database DB2


  1. Create a report on the database view.
  2. Select the Database menu in Crystal Reports -> Show SQL Query.
  3. Copy the SQL.
  4. Create a new report and add the command.
  5. Paste the copied SQL and then add WITH UR to the SQL.
  6. Replace all the connection that are using database view to the new connection that has command.


WITH UR, Uncommitted Reads, dirty read. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


Crystal Reports 2008 V1