devxlogo

Query from One Informix Database to Another

Query from One Informix Database to Another

Question:
I have two Informix databases existing on a Unix server. How do I write a stored procedure in one database that can access data from the other database?

Answer:
The following syntax shows you how to access a table in another database:

SELECT fieldnameFROM  otherdatabase:tablenameWHERE blah.....

This works from within stored procedures.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist