Connecting Tech Pros Worldwide Help | Site Map

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

  #1  
Old November 7th, 2008, 03:45 PM
flea2k
Guest
 
Posts: n/a
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
================================================== ==========

  #2  
Old November 7th, 2008, 03:45 PM
flea2k
Guest
 
Posts: n/a

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


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."
  #3  
Old November 7th, 2008, 05:05 PM
flea2k
Guest
 
Posts: n/a

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


On Nov 7, 9:39*am, flea2k <jeremyt...@gmail.comwrote:
Quote:
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.
  #4  
Old November 7th, 2008, 05:15 PM
Mark A
Guest
 
Posts: n/a

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


"flea2k" <jeremytlee@gmail.comwrote in message
Quote:
news:fc7df269-1b3e-423f-a9c7-b0c35e1ffbe1@e38g2000prn.googlegroups.com...
On Nov 7, 9:39 am, flea2k <jeremyt...@gmail.comwrote:
Quote:
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.


Closed Thread