"WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token

[flea2k]

I am trying to run this select statment against my DB2 database and it
is throwing the following error, is there a setting in my db2 database
to allow for this call "USE AND KEEP UPDATE LOCKS"?

SELECT * FROM user.tableA WHERE FIRST_NAME ='Billy' WITH RS USE AND
KEEP UPDATE LOCKS
SQL0104N An unexpected token "USE AND KEEP UPDATE LOCKS" was
found following "Billy' WITH RS". Expected tokens may
include: "<space ".

If I just run SELECT * FROM user.tableA WHERE FIRST_NAME ='Billy'
WITH RS it works just fine.

My DB2 info:

================================================== ==========
About DB2 Administration Tools Environment
================================================== ==========
DB2 administration tools level:
Product identifier SQL08010
Level identifier 01010106
Level DB2 v8.1.0.36
Build level s021023
PTF
================================================== ==========
Java development kit (JDK):
Level IBM Corporation 1.3.1
================================================== ==========

[flea2k]

I just read this somewhere, it may be the problem:

"As I know, the lock request clause was introduced with DB2 v8.1 FP7
which matches the first release of v8.2."

[flea2k]

On Nov 7, 9:39*am, flea2k <[e-mail]:

I just read this somewhere, it may be the problem:

"As I know, the lock request clause was introduced with DB2 v8.1 FP7
which matches the first release of v8.2."

I updated to fixpack 17 and the problem went away so it was a version
issue.

[Mark A]

"flea2k" <je********@gmail.comwrote in message

news:fc**********************************@e38g2000 prn.googlegroups.com...

On Nov 7, 9:39 am, flea2k <[e-mail]:

I updated to fixpack 17 and the problem went away so it was a version
issue.

Since you were previously running FP 0 (8,1 GA code) before upgrading to FP
17, and there are on average over 300 APARs fixed in each fixpack (usually
more), you have also resolved at least 5,099 other problems.