Sounds perfect for cursor work! Each cursor could be in a different work area, and then you can use a SELECT ALIAS to move among them, or just treat them as tables in your SQL commands.
>>>Use a cursor instead of a table. That way the "alias" name
>>>is whatever you want it to be, and can be referenced as a
>>>normal table. A cursor may have an
>>>actual filename, but you don't need to concern yourself
>>>with that, and it will clean up after itself when you're done with it.
>
>Hi, Fred....the problem (at least I thought) with cursors is that they really only work in the current work area. I have about four files that I need to work with at the same time... and I select between them
>
>--- L
--Todd Sherman
-Wake Up! Smell the Coffee!