Hi,
Just to let you know that SELECT...FOR UPDATE does not work even in JDBC for SAPDB
ver 7.3.0.25.
Regards,
Ajit
Message: 2
From: "Zabach, Elke" <[EMAIL PROTECTED]>
To: =?iso-8859-2?Q?=27Jan_Hlavat=FD=27?= <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: RE: FOR UPDATE's optional subclause [OF <fieldname>] not optional
?
Date: Mon, 30 Dec 2002 09:32:06 +0100
Jan Hlavat�wrote:
> I've found a discrepancy between documentation and actual behavior:
> When I try SELECT ... FOR UPDATE, it complains about missing
> OF keyword
> ( -5015: Syntax error or access violation).
>
> But update_clause in syntaxlist lists:
>
> <update_clause [Extern]> ::= FOR UPDATE [OF <column_name
> [Page 15]>,...]
>
> Which means that it should be optional???
I have to assume that you are talking about the version 7.3.
For this (as written before and could be found in the archive)
Usually 'FOR UPDATE' is fine, even with SAP DB.
BUT
If you are using ODBC or a tool using ODBC (like SQLStudio, for example)
then OF is mandatory, according to ODBC-standard.
The semantic of FOR UPDATE, FOR UPDATE OF and FOR UPDATE OF <columnlist>
is the same.
For 7.4 FOR UPDATE (without OF) is allowed even for ODBC-connections.
Elke
SAP Labs Berlin
--__--__--
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
