I'm using DB2 126.96.36.199 for AIX. I want to select data from a remote database, also running DB2 188.8.131.52 for AIX, and insert it into the local database I'm connected to. I believe the query for this ...
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
While connected to our production server (SQL2008. very powerful machine), this select statement takes 2 seconds, spitting back all fields (4 MB of data in total). select top 30000 * from person ...