Hi All,

We are using DB2 UDB version 7 as the database for our project. This is
installed on windows environment. The actual prod environment is DB2 on
mainframe.

When we execute simple select queries on our local database with
"with ur" (Uncommitted read isolation level) option we are getting
the following error message.

db2 => select * from altn_type_mstr with ur

SQL0104N  An unexpected token "ur" was found following "altn_type_mstr
with".Expected tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601

DB2 is not able to recognize with ur option at all.

The same statement is running fine on prod environment.

I think we have missed something while installing or configuring the
server or the database. Can any one help us in resolving this issue?

Thanks in advance.
Srini