内嵌SQL语句问题

[sha256cn]

一个STRING变量的值是一段SQL语句,在POWERSCRIPT中有何函数可以运行此变量里的语句?谢谢

[Icon]

ls_sql = "select ....... into ...... from ....where"
execute immediate :ls_sql;

[sha256cn]

谢谢,怎么判断执行是否成功?

[fakeer]

lb_autocommit=bgo.transobject[1].autocommit
bgo.transobject[1].autocommit=true

//执行日志清理
bgo.mdiframe.setmicrohelp("正在进行日志清理...")
ls_sql="DUMP TRANSACTION "+ps_dbname+" WITH TRUNCATE_ONLY"
execute immediate :ls_sql using bgo.transobject[1] ;

if bgo.transobject[1].sqlcode<0 then
bgo.transobject[1].autocommit=lb_autocommit
bgo.ErrorMsg="日志清理失败!"
return bgo.transobject[1].sqlcode
end if

bgo.transobject[1].autocommit=lb_autocommit
bgo.mdiframe.setmicrohelp("日志清理完毕.")
bgo.ErrorMsg="日志清理完毕."

[Icon]

if sqlca.sqlcode <> 0 then
//错误
else
//成功
end if