Re: Table split into separate server and instance

"Ganesan Subramanian" <gsubrama.news.invalid@web2news.net> wrote in message news:<41802N182@web2news.com>... > > This is error because there is no entry about test engine in > /$INFORMIXDIR/etc/sqlhots. I can guarantee u that I've all the necessary settings in sqlhosts and /etc/services. I hv no problem when I set INFORMIXSERVER=TEST and run this in dbaccess :- "select a.branch_code, a.user_id, b.branch_code, b.user_id from code_pwdaccess a, code_pwdaccess b where a.user_id = b.user_id" But I do hv problem when I explicitly include the instance's name "select a.branch_code, a.user_id, b.branch_code, b.user_id from db4@TEST:code_pwdaccess a, db6@TEST:code_pwdaccess b where a.user_id = b.user_id"