ImportText locking level & duplicates

[Ruslan Zasukhin]

On 3/10/11 2:10 PM, "harald.schlager at glyps.com" <harald.schlager at glyps.com>
wrote:

Hi Harald,

> when i make a "bulk"-insert via VCursor.ImportText() is there a lock on
> row or on table or are there lockescalations ?

Your cursor is ServerSide  ReadWrite,
To be able write into it.
 
New records added into underline table and are locked for RW.
So you can use them in this cursor right after import.


> what happens if rows exists (discard, update, abend, ..  ) ?

Import Rows with Duplicate keys are skipped of course.
 
> are there other restrictions (maybe no indexbywords possible ... ) ?

No such restriction ...



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]