>Hi to all,
>
>I've created my views on the connection myConnection, with a command like this:
>
>CREATE SQL VIEW myView REMOTE CONNECTION myConnection SHARE AS ....
>
>If in the command window I do:
>
>myConnHandle = SQLCONNECT('myConnection')
>
>USE myView
>
>I think that view open another connection, and don't use the first connection.
>
>Can you say me something about this ?
Hi,
When you create a remote view using CONNECTION of DBC, You don't have to pass/get connection handle to this Remote View while opening it using USE command. Whenever you do USE MyView, It internally connects to remote database using the connection which the Remote View is based on.
Bye
Jayesh
- Jayesh