Hi Fabio,

I am sorry, it is not clear for me what you are trying to ask.

SPT cursors transactable by default, don't they?
If a cursor is not transactable, table buffering should be switched off before it can be made transactable (I am talking about MAKETRANSACTABLE() function). After the cursor is made transactable, it can be switched to table buffering without any problem.

Does this answer your question? If not, please try to explain more clearly what is it you would like to do. Perhaps with some code examples.

Thanks,
Aleksey.


I think you have understood well

To close the issue,
You can comment these sequences and confirm if it is all correct.

* for one DBC table/view or for a SPT Cursor
* allocate one of these into a WorkArea
* define a index
* set table buffering
* define another index  : this action is not possible
* BEGIN TRANSACTION
* define a index        : this action is not possible
* change buffering      : this action is not possible

* for one FREE table o for one temporary Cursor
* allocate one of these into a WorkArea
* define a index
* set table buffering
* MAKETRANSACTABLE()	: this action is not possible
* set no buffering
* MAKETRANSACTABLE()	
* set table buffering
* BEGIN TRANSACTION
...

Thanks
Fabio