The SELECT - SQL Command with INTO CURSOR clause can create a filtered cursor under following conditions:

• Only one table is referenced by the query
• WHERE condition is fully optimizable and can be represented by SET FILTER TO command
• In the Select list either '*' specified (all fields) or subset of the fields from the table
• No additional clauses, like DISTINCT, ORDER BY, GROUP BY, etc., are present
• SET EXACT and SET ANSI settings match