declare qt VARCHAR(300);
DECLARE st STATEMENT;
set qt ='INSERT INTO MAIN
select ''v0002'',replace(substr(a.Ce,1,7),''-'',''''),''0'',
a.ae,a.ccode,a.qno,a.po,a.CNo,a.Ce,a.Be,a.ee,a.ete,
b.le,b.me,b.ue,b.lo,b.vin,b.eo,
c.Re,a.TPremium from
(a inner join b on a.CNo=b.CNo) inner join
c on c.CNo=a.CNo and c.RCode=3 where 1=1';
PREPARE St FROM qt;
EXECUTE St;
[Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;.vin,b.eo,c.R;
, DRIVER=3.57.82
大牛门帮忙看下~谢谢~~~收起