Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    36

    Unanswered: Can I create a temporary table to two databases at the same time

    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.

    thanx

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    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.

    Wrappers
    Identify the modules (DLL, library, and so on) used to access a
    particular class or category of data source.
    Servers
    Define data sources. Server data includes the wrapper name, server
    name, server type, server version, authorization information, and
    server options.
    Nicknames
    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.


    Cheers

    Sathyaram

    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.

    thanx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •