create a view in sql server reading from a linux server informix database using ODBC connection

Question

how can i create a view in sql server reading from a linux server informix database. I'm using an ODBC connection

Answer 1

Since a view is essentially just the resultset of a query applied to one or more tables, once you have the connection you should be able to define the appropriate SQL query to it that gives you your view.