If what you meant by on-the-fly is programmatically, then:

CREATE SQL VIEW myRemoteView REMOTE CONNECTION myDataSource AS ;
       SELECT * FROM Customer WHERE AreaCode = ?pAreaCode

>to be specific,
>how can I use an on-the-fly paramatized view using ODBC