>>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.

Hilmar.