Not able to assign select query "WITH UR" CLUSE TO A VARIABLE

Hi,
i'm using Db2 Version 8.2.

in a stored procedure i'm assiging a the result of sql query ( with
"WITH UR" ) to a variable as shown below.


 SET v_temp =  ( SELECT 1 FROM
                                      Table_1 A , Table_2 B
                                    WHERE  a.cd=b.cd  )
                    	      WITH UR;

But i'm getting the fallowing syntax error.

An unexpected token "WITH UR" was found following " ".  Expected
tokens may include:  "<space>".  LINE NUMBER=91.  SQLSTATE=42601

i even tried to put that cluase inside the bracket but no luck.

can any body please suggest be the work around for this.

Thanks,
Situ