Andreas Bohn wrote.

> COMMIT KEEP LOCK throws Err -9000
> =================================
> 
> Kernel:          7.3.0  Build 029-000-087-809
> RTE:    NT/INTEL 7.3.0  Build 029-000-087-809
> 
> Instance Type: OLTP 
> 
> Isolation Level: 0 (null)
> 
> 
> The following code fragment throws error -9000 (System error: Not yet
> implemented)
> 
> 
>   EXEC SQL 1 PREPARE dbCommitKeepLock FROM
>     "COMMIT WORK KEEP LOCK ROW theusers KEY id = '0123456789' 
> OPTIMISTIC";
> 
>   EXEC SQL 1 EXECUTE dbCommitKeepLock;
> 
> 
> Will this come in future releases of SAP DB and if yes when ?

This KEEP LOCK...-option for COMMIT / ROLLBACK was planned
several years ago.
But now AND IN THE FUTURE it will not be implemented.
We checked it today and it will not be possible together with planned and
(half implemented) changes.

--> we will throw it out of the document

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to