Question 3 Replies 136 Views × Close popover Dhivya Jeevan (DhivyaJ07) Greensill Greensill IN View Profile Send Message DhivyaJ07 Member since 2014 5 posts Greensill Posted: June 4, 2019 Last activity: June 7, 2019 Posted: 4 Jun 2019 2:29 EDT Last activity: 7 Jun 2019 6:22 EDT Closed RDB methods and Connect SQL rule Can somebody please help me with the below question? How to conditionally call a Connect-SQL rule using RDB methods? Scenario: I have some properties set in my activity on 1-3 steps and on 4th step i am using RDB method which should call a Connect-SQL rule based on the condition. How can we achieve this? Data Integration Java and Activities × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover 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: 1 year ago Posted: 4 Jun 2019 3:19 EDT × Close popover Marc Lasserre (MarcLasserre_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. FR View Profile Send Message MarcLasserre_GCS PEGA replied to DhivyaJ07 Hello, I'm not sure to get the question. Can you just add your RDB method on step 4 with a WHEN condition? Posted: 1 year ago Posted: 7 Jun 2019 1:28 EDT × Close popover Dhivya Jeevan (DhivyaJ07) Greensill Greensill IN View Profile Send Message DhivyaJ07 Greensill replied to MarcLasserre_GCS Hi, For e.g., I have 2 Connect-SQL rules (SQL1 and SQL2) and I have to call one of them in RDB method from an activity based on a condition. Which means only one RDB method should be able to call any one of these SQL rules based on a condition. Hope my requirement is clear now. Posted: 1 year ago Posted: 7 Jun 2019 6:22 EDT × Close popover Vivek Bommayappan (VIVEKATCTS) Cognizant Cognizant IN View Profile Send Message VIVEKATCTS Cognizant replied to DhivyaJ07 Hi, Connect -SQL name is the value for the RequestType parameter in the RDB methods. You can select it based on your condition. Based on your condition, you can set the SQL names and you can pass it to the RDB method. Property-Set : Local.ReqType = @if(.YourProperty=="Value","SQL1","SQL2") RDB Method: (eg) ClassName: X-Y-Z RequestType: Local.ReqType Access : Oracle Hope it will help you.