论坛 › Informix › 谁能帮帮我~

loxuma 发表于 2010-10-29 15:50

谁能帮帮我~

$dbaccess -V
DB-Access Version 9.40.FC4   
$onstat -
IBM Informix Dynamic Server Version 9.40.FC4
$esql -V
IBM Informix CSDK Version 2.80, IBM Informix-ESQL Version 9.52.UC1

现在在dbaccess 里查询可以用
select f_08,f_11,(case when a.bz='*' then '1' else '0' end),gylsh,jyje,bczbz
from yw_fsyw_ywlsz a full join yw_fsyw_hxdzmx b
on a.f_08=b.gylsh
where (jydm is null)

但在用c写程序时编译报错
Error -33051: Syntax error on identifier or symbol 'full'

C代码:
EXEC SQL declare hxbpmx_cur cursor for
select f_08,f_11,(case when a.bz='*' then '1' else '0' end),gylsh,jyje,bczbz
from yw_fsyw_ywlsz a full join yw_fsyw_hxdzmx b
on a.f_08=b.gylsh
where (jydm is null)

请大家帮帮我吧~是什么原因呀~:curse:

yunzhongyue 发表于 2010-10-29 18:57

我猜可能是CSDK版本太低！

查看完整版本: 谁能帮帮我~