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