Question3Replies100Views DhivyaJ8 Member since 2014 3 posts Accenture Posted: June 4, 2019Last activity: June 7, 2019 Closed RDB methods and Connect SQL ruleCan 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 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: 1 year agoMarcLasserre_GCS PEGA replied to DhivyaJ8Hello, 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 agoDhivyaJ8 Accenture replied to MarcLasserre_GCSHi, 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 agoVIVEKATCTS Cognizant replied to DhivyaJ8Hi, 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.