Question5Replies887Views×Close popoverRay (PoojaRay) View Profile PoojaRay Member since 2016 1 post Posted: July 22, 2015Last activity: April 25, 2017Posted: 22 Jul 2015 8:20 EDTLast activity: 25 Apr 2017 6:07 EDT 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 agoPosted: 22 Jul 2015 8:31 EDT×Close popoverPhani Sahukaru (sahup1) PEGA Associate Architect - Financial Services Pegasystems Inc. IN View Profilesahup1 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 agoPosted: 22 Jul 2015 8:37 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profilenistr 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 agoPosted: 23 Jul 2015 7:06 EDT×Close popoverRay (PoojaRay) View ProfilePoojaRay 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 agoPosted: 10 Aug 2015 3:45 EDT×Close popoverRay (PoojaRay) View ProfilePoojaRay 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 agoPosted: 10 Aug 2015 4:48 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View Profilenistr PEGA replied to PoojaRayRight, you can generate the SQL using data transforms but you need an activity or function to execute it.