>How can I create a union in a remonte view(connected to Oracle)?

You have to create the SQL command programmatically:

create sql view myview remote connection myconnection [share] as ;
   select ... from mytable1 where ... ;
   union ;
   select ... from mytable2 where ... ;
   order by ... group by ...

The fields in the both Select lists have to be identical types, and the order by and group by clauses can only be placed at the end of the union. To make the view updatable, you can dowlnload Erik Moore's EVIEW file to finish the view design.

I keep a file of all code used to generate views in a PRG so I can recreate any view at any time. The code for each view is its own procedure in the PRG and includes all the DBSETPROPs and CURSORSETPROPs in order to make the updatable if applicable.