Re: Table split into separate server and instance

Did you try making the servername lower case (test) in the query? Art S. Kagel ----- Original Message ----- From: Kh Teoh <khteoh2001@YAHOO.COM> At: 6/20 2:18 > "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" sending to informix-list