>>Space IS an issue. Our app does lots of queries and some of them can be quite large. The cursors are stored to temp files during processing.
>
>that kind of work should be done on the network server, not brought down locally... add a temp directory to your dir structure on the network and do it there...

Dave -

I'm guessing that you have never run a really HUGE query with tempfiles sitting on the network. I made that mistake once. And, after having the other 3 customer areas, the Network Support Specialist (NSS) for that network, and about 10 other programmers (whose work got crapped out when the network choked and gagged) bounce off my head (apparently they weren't REAL keen on a network that essentially quit working), I decided that perhaps I should go out of my way to make SURE that my tempfiles went somewhere other than the network. Especially if it's a Novell network.