EXEC SQL INCLUDE sqlca;
tst()
{
EXEC SQL BEGIN DECLARE SECTION;
char sCrdNo[25+1];
char sTxnDt[10+1];
char sSndBnk[11+1];
char sSumMny[36];
EXEC SQL END DECLARE SECTION;
EXEC SQL
SELECT char(sum(txnamt)) into :sSumMny
FROM gctact
WHERE crdno = :sCrdNo and
substr(sndbnk,5,4) = :sSndBnk and
txndate = :sTxnDt and
sta = '0'and
revcd = '0'and
txncod ='22031';
}
------解决方案--------------------------------------------------------
没输入参数
------解决方案--------------------------------------------------------
参数没有值吧
------解决方案--------------------------------------------------------
参数没有值吧