ESQL/C ONLINE 5.0 多庫操作問題

wkl

ESQL5 ONLINE 5
請教各位高手,我現(xiàn)在兩個庫,D1庫有CONN權(quán),有個表T1,D2是我建的,有個表T2,我想在D1查的游標中向D2insert,我是這樣寫的
....
$database d1
$declare xxx curosr for select zh into $v_zh from t1;
$open xxx
$fetch xxx;
while(sqlca.sqlcode==0)
{
    $database d2
    $insert into t2 values($v_zh);
    $fetch xxx;
}
.....
可是后來出現(xiàn)267錯誤,WHILE循環(huán)中的數(shù)據(jù)量很少,好象是游標斷了,請教,怎么才能實現(xiàn)在一個庫查詢,在另一個庫寫,而且游標不釋放?????
如能解答,不勝感謝!!~~

wkl

沒人回答嗎?

xxyyy

$connect to d1 as "d1" WITH CONCURRENT TRANSACTION;
$connect to d2 as "d2" WITH CONCURRENT TRANSACTION;

$set connection "d1";
$declare xxx curosr for select zh into $v_zh from t1;
$open xxx
$fetch xxx;
while(sqlca.sqlcode==0)
{
     $set connection "d2";
     $insert into t2 values($v_zh);

     $set connection "d1";
     $fetch xxx;
}

[ 本帖最后由 xxyyy 于 2007-6-27 16:43 編輯 ]