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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: