How to populate to_number() function in parfiles SQLs?

[Subhash Chandra Chamala]

Hi,

Trying to understand that how can we populated to_number() for ID columns in generated parfiles SQL?
can we do any setup in DataMaker to auto generate to_number()

Ex:

query=GWCC.CC_CATASTROPHECLAIMSHISTORY:" where ((CATASTROPHEID) in (select L736.ID from (SELECT * FROM GWCC.CC_CATASTROPHE L736) L736 where (ID) (to_number(ID)) in (select L0.CATASTROPHEID from (SELECT * FROM GWCC.CC_CLAIM L0 where L0.ID in (SELECT ID FROM TDMSOURCE_SVC.CC_TDM_DRIVER WHERE PROCESSEDFLAG='U')) L0)))"

------------------------------
Thanks,
Subhash Chamala
CA TDM Developer
------------------------------