Question5Replies864Views PoojaRay Member since 2016 1 post Posted: 5 years agoLast activity: 5 years 1 month ago Closed Solved Can we update Sql in data transform using data transformCan we update Sql in data transform using data transform***Updated by moderator: Lochan to add Categories*** Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 5 years agosahup1 PEGA replied to PoojaRayis the use case to build the query using properties pxSelectStatement & pyWhereClause and call RDB- methods to process the query? if yes, we could build the query from data transforms. Posted: 5 years agonistr PEGA replied to PoojaRayI am not sure I understand the intent of generating SQL through data transforms. Could you elaborate on the use cases which need custom SQL generated through data transforms? Posted: 5 years agoPoojaRay replied to PoojaRayIn need to update some value of internal database , I know it can be down through activity, just wanted to be sure whether it can be done through data transform. Posted: 5 years agoPoojaRay replied to PoojaRayI dont think using data transform sql table can be updated, only set or data manipulation can be done through data transform but it can perform other methods which is easily done through activities . Accepted Solution Posted: 5 years agonistr PEGA replied to PoojaRayRight, you can generate the SQL using data transforms but you need an activity or function to execute it.