How do i connect to multiple databases within one qvw file? can there be more than one connect statments in qvw script?
You can use multiple connects, but there is only one connection active at a time. A CONNECT statement will do a disconnect of any existing connect, or you can explicity DISCONNECT. So something like this:
SQL SELECT ..
Retrieving data ...