Re: Another IDS Feature Request

Art S. Kagel wrote: > Several days ago I proposed the following as part of a reply. I got no > comments on it. Did everyone miss it? Or is it just dumb? > > Explicit globally accessible cursors. > [...] Why stop at cursors? Wouldn't it be nicer to be able to reconnect to a previous session? You'd get to keep all of your existing cursors *and* temporary tables. Transactions as well, so a that you could have (something like): BEGIN WORK; {some sql} SAVE SESSION AS :id; {client hangs up} ... {client reconnects}; RESTORE SESSION :id; {some more sql} COMMIT WORK; It'd need, or you'd want, a timeout, I suppose. -- rh