Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MrRaleigh
Starting Member
1 Post |
 Posted - 2005-11-10 : 10:55:32
|
| Hi, I'm having trouble querying an IBM AS/400. I have a Java servlet with a function which uses the following SQL:SELECT ZTUSER, ZTITNO, ZTROUT FROM MRCDEV.ZTROLINE INNER JOIN MVXCDTA300.MITATP ON ZTITNO=MAITNO AND ZTRWHS=MAWHLO WHERE ZTUSER='"+user+"' AND MAAVTP>0 AND ZTRWHS='110' AND MAPLDT=0 FOR UPDATE OF ZTROUTI'm getting the error: "FOR UPDATE CLAUSE NOT VALID"Can anyone help? Any pointers would be much appreciated. . . Many thanks in advance. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-11-10 : 11:39:06
|
| See item #1 in the list of things to be aware of before you post a question.http://www.sqlteam.com/askus.asp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-10 : 23:59:15
|
| Post your question at Oracle Forum of www.DBforums.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
For Update Clause Not Valid