开发者

Translate function binding issue

开发者 https://www.devze.com 2023-03-21 00:55 出处:网络
I am using SQLJ as the data set is quite large for the application. I am trying to incorporate a query into my SQLJ file, but at the time of binding it gives me an error. Please help me with an altern

I am using SQLJ as the data set is quite large for the application. I am trying to incorporate a query into my SQLJ file, but at the time of binding it gives me an error. Please help me with an alternative to the same. I cannot drop the translate function as I have been told to do that only.

sql [myConn] cursor = { SELECT ORD_TEMPLT_GRP_ID,DSO_CD, ACCT_SUBTYPE_CD, 
GRP_DESC,LAST_CHANGED_BY_ID
FROM TEMPLATE_GRP
WHERE
TRANSLATE(ORD_TEMPLT_GRP_ID) = TRANSLATE(:templateGp)
WITH UR };

cursor over here is iterator and templateGp is the valu开发者_如何学Goe which I am getting from an object.

0

精彩评论

暂无评论...
验证码 换一张
取 消