Re: Can I create a temporary table to two databases at the same time
You are talking about Federated Databases. The following are the three components of federated systems. As a beginner, you can define these from the Control Centre. You can use SQL Statements to achive the same. For further details have a look at the Admin Guide under the chapter Federated Systems.
Identify the modules (DLL, library, and so on) used to access a
particular class or category of data source.
Define data sources. Server data includes the wrapper name, server
name, server type, server version, authorization information, and
Identifiers stored in the federated database that reference specific data
source objects (tables, aliases, views). Applications reference
nicknames in queries just like they reference tables and views.
Originally posted by sandips
I am connected to a particular database. Is it possible to create a temporary table in another database taking data from the first database?
If possible, can you please give the syntax.