Prev: Prune on HADR standby
Next: Documentation on db2pd
From: Tonkuma on 4 Feb 2010 11:59
> select max(sal) from table_billion FOR READ ONLY WITH UR;
> wont work.. syntax error.
Did you run exactly same as the example?
Was that "select max(sal) INTO ..."?

Looking into manuals "DB2 SQL Reference, Volume 2"...
FOR READ ONLY clause was not supported in SELECT INTO statement on DB2
9.5 on LUW.
It is supported on DB2 9.7 on LUW.
 | 
Pages: 1
Prev: Prune on HADR standby
Next: Documentation on db2pd