SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • Crystal Reports 2008
  • Database DB2

Resolution

  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.

See Also

http://scn.sap.com/thread/1668905

Keywords

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

Product

Crystal Reports 2008 V1