informix + sqlserver 高手请进: 解决我把全部分给你！

[eastxiang]

sqlserver:
declare @sql varchar(255)
select @sql = 'select * from table_1'
execute(@sql)

如何在informix 实现，这种动态执行SQL。

[eastxiang]

我的informix版本是：IBM Informix Dynamic Server Version 9.40.UC4W2

[wzbstudy]

据我所知，informix好像不支持动态SQL语句的啊。

[wzbstudy]

但是你可以把你处理的结果放在临时表内，再展示临时表；

[lzx130]

和在sqlserver2000一样啊
你想得到就做得到啊

[yaoyz999]

下面是一段ec程序,看看是不是你想要的;
int dbexecute(char *ssql1)
{
int i=0;
$char ssql[3000];
strcpy(ssql,ssql1);
$prepare dbexec from :ssql;
if( SQLCODE<0)
{
printf("prepare error %d,for %s\n",SQLCODE,ssql);
i=SQLCODE;
return i;
}
$execute dbexec;
if( SQLCODE<0)
{
printf("execute error %d,for %s\n",SQLCODE,ssql);
i=SQLCODE;
return i;
}
$free dbexec;
if(DBBUG==1)
{
system("date");
printf("success for %s\n",ssql);
}
return i;
}

[tommyyuyong]

INFORMIX 一定是支持动态的SQL语句看看下面的代码:
LET l_sql=" SELECT * FROM oik_file ",
" WHERE oik21='Y' AND ",
" ((oik06='RMB' AND oik09>oik091 ) OR ",
" (oik06<>'RMB' AND oik09f>oik15f and oik14f<>0 )) AND ",
tm.wc CLIPPED,
" AND oik03='",tm.year1 clipped,"'"


PREPARE anmp800_prepare1 FROM l_sql
IF SQLCA.sqlcode != 0 THEN
CALL cl_err('prepare:',SQLCA.sqlcode,1) EXIT PROGRAM
END IF
DECLARE anmp800_curs1 CURSOR WITH HOLD FOR anmp800_prepare1

FOREACH anmp800_curs1 INTO g_oik.*
IF SQLCA.sqlcode != 0 THEN
CALL cl_err('foreach:',SQLCA.sqlcode,1)
EXIT FOREACH
END IF
............
END FOREACH

[learnlife]

EC&4GL支持，procedure不支持。

[zxs3543]

#include <stdio.h>
#include <sqlca.h>
#include <sqlda.h>
#include <sqltypes.h>
#include <sqlstype.h>

main()
{
EXEC SQL INCLUDE SQLCA; /*定义通信区*/

EXEC SQL BEGIN DECLARE SECTION; /*主变量定义开始*/
EXEC SQL END DECLARE SECTION; /*主变量定义结束*/
EXEC SQL DROP DATABASE example;
EXEC SQL CREATE DATABASE example;
EXEC SQL DATABASE example; /*连接数据库*/
if (SQLCODE==0)
{
EXEC SQL CREATE TABLE Student
( alarm char(6) ,
sname char(10)
);


}
EXEC SQL INSERT INTO Student VALUES("aaaa","bbbb");

return(0);
}