论坛 › Informix › SQL查詢語句--errno 934

xueyu_net 发表于 2010-06-25 17:26

SQL查詢語句--errno 934

執行如下SQL：

select unique efa08,efa17,efaconf,pmc03 from
efa_file,outer pmc_file
where efa08=pmc01 and efa02='1Pe-A20043'
and efaconf='Y' and efa26<>'5'
and efa23='Y'
   934: 對於遠端系統的連接已不再正確.

若將SQL 更改一下就可以執行

select unique efa08,efa17,efaconf,pmc03 from
pmc_file,outer efa_file
where efa08=pmc01 and efa02='1Pe-A20043'
and efaconf='Y' and efa26<>'5'
and efa23='Y'

請指教！謝謝！

liaosnet 发表于 2010-06-28 11:52

-934

__________________________________________________________

Connection to remote site no longer valid.

This statement uses data from another computer system, but the connection has been lost. Roll back the transaction, and try again after you reestablish the connection.

查看完整版本: SQL查詢語句--errno 934