In theory no, in practice yes, but no guarantee. This is from help: The name that SYS(2015) returns is created from the system date and system time. Calling SYS(2015) more than once during the same millisecond interval returns a unique character string. But why not give the cursor a meaningful name?


>Tore --
>
>Is SYS(2015) guaranteed to always return distinct names?
>
>Jim
>
>
>>Hi James,
>>
>>maybe you can name your cursors according to the level of recursing? Something like

>>lcCursorname=lcCursorname+'1'
>>Select * from sometable into cursor (lcCursorname) where bla-bla-bla

>>Just an idea..! :-)