>>>Hi,
>>> How to CREATE CURSOR in selected workarea?
>>> How to SELECT ...INTO CURSOR in particular workarea?
>>
>>Does SELECT 0 solve the problem?
>>
>>> I face a problem "cannot access the selected table". I found that, it caused by my temporary cursor and my query result appear in same workarea. How to seperate it?
>>
>>If SELECT 0 doesn't help, what are the series of commands causing the trouble?
>
>SELECT 0 is OK for CREATE CURSOR; otherwise, I think, the cursor will be created in the current work area. SELECT 0 is preferable to, e.g., SELECT 5, since you can be sure that SELECT 0 will select an un-used area.
>
>SELECT ... INTO CURSOR automatically creates the cursor in an un-used area, so you should have no problems there. I see no reason to try to create the cursor in a specific area.

Hi, Hilmar-

Did you mean to address this to John?