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.

devx-admin

Share the Post: