在SQLSERVER2000,我们常常可以用一个字符串变量来存储SQL语句,然后用EXECUTE来执行它,如: set @sp_SQLSTR='update tablename set fd1=xx'; EXECUTE SP_EXECUTESQL @sp_SQLSTR; 那么在DB2里有没有类似这种作用的语句?
两种方案:
1、用immediate,
declare Mysql varchar(1024);
set Mysql ="update tablename set fd1=xx";
EXECUTE IMMEDIATE Mysql;
2、用prepare
declare Mysql varchar(1024);
set Mysql ="update tablename set fd1=xx";
prepare str1 from Mysql;
EXECUTE IMMEDIATE str1;