Dear all,
Thanks for your help in -- -- Now the CIS has been configured successfully and the test is OK--
(DBA)> forward to r1 {select count(*) from spxtest.dba.load_test};
count()
--------------------
0
(1 rows)
But still some problem in CIS -- when I create a proxy table with --
(DBA)> create existing table pr_spx_load_test at 'r1.spxtest.dba.load_test';
Could not execute statement.
The remote table 'r1.spxtest.dba.load_test' could not be found
SQLCODE=-666, ODBC 3 State="HY000"
Line 1, column 1
create existing table pr_spx_load_test at 'r1.spxtest.dba.load_test'
Press ENTER to continue...
But as my previous test -- we can see the CIS can access that load_test on remote server r1...I don't know why the "create existing table" statement can't find that remote object.
Please kind help again. Thanks
Regards
Eisen