以下两句是sybase的语句，如何转换成为informix下的语句：
EXEC SQL update T_PB_JOURNAL set ModiStatus=B.ModiStatus
from T_PB_JOURNAL A,T_PB_MODIFY B
where A.TranDate=B.TranDate
and A.AreaNo=B.AreaNo
and A.AreaNo=:areano
and A.BusiType=B.BusiType
and A.JourNo=B.JourNo
and A.TranStatus='3';
此句informix报错为：from没有定义

EXEC SQL INSERT INTO T_ADM_MONTH_IT
SELECT :month,
AreaNo,
InstNo,
BusiType,
PayMode,
sum( SuccNum ),
sum( FailNum )
FROM T_ADM_DAY_IT
WHERE TranDate >= :begindate
AND TranDate <= :enddate
AND AreaNo = :area_no
GROUP BY AreaNo, InstNo, BusiType, PayMode
ORDER BY AreaNo, InstNo, BusiType, PayMod;
此句报错为：ORDER没有定义
向各位大侠求救