Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Sep 19, 2000

Accessing External Table

Question:
How do I define an external table (that is not in my current database) in Informix and access the data in it?

Answer:
If you're connecting to an external Informix database, assuming that you have the proper I-Connect links between the systems, you would access the remote table as follows:

SELECT * from database@server_name:table_name;
If it's a non-Informix database you want to connect to, explore the virtual table interface (VTI)—if you're on an engine beyond the 7-series.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap