On May 9, 5:03=A0pm, Tonkuma <tonk...@[EMAIL PROTECTED]
> wrote:
> (I didn't tested following opinion.
> =A0I was only refered the manuals
> =A0"DB2 for LUW SQL Reference Volume 1 Version 8" and
> =A0"DB2 for LUW SQL Reference Volume 2 Version 8".)
>
> 1) Your SET statement violates the following syntax of SET statement
> and "fullselect".
>
> SET (variable1, variable2, ..., variablen) =3D (row-fullselect);
> or
> SET variable =3D expression;
> "expression" includes (scalar-fullselect).
>
> You can't specify "isolation-clause" in a "fullselect".
>
> Please try:
> SELECT 1 INTO v_temp
> =A0 FROM Table_1 A , Table_2 B
> =A0WHERE a.cd =3D b.cd
> =A0 WITH UR;
>
> 2) I afraid that the SELECT statement may return multiple rows, and
> get error.
> If there is such possibility, it would be better to add "FETCH FIRST 1
> ROW ONLY".
Thanks u very much , it worked !!
|
