Question3Replies122Views×Close popoverDhivya Jeevan (DhivyaDJ) Accenture Accenture IN View ProfileSend Message DhivyaDJ Member since 2014 5 posts Accenture Posted: June 4, 2019Last activity: June 7, 2019Posted: 4 Jun 2019 2:29 EDTLast activity: 7 Jun 2019 6:22 EDT 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 ×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 agoPosted: 4 Jun 2019 3:19 EDT×Close popoverMarc Lasserre (MarcLasserre_GCS) PEGA Principal Software Solutions Engineer PEG FR View ProfileSend MessageMarcLasserre_GCS PEGA replied to DhivyaDJHello, 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 agoPosted: 7 Jun 2019 1:28 EDT×Close popoverDhivya Jeevan (DhivyaDJ) Accenture Accenture IN View ProfileSend MessageDhivyaDJ 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 agoPosted: 7 Jun 2019 6:22 EDT×Close popoverVivek Bommayappan (VIVEKATCTS) Cognizant Cognizant IN View ProfileSend MessageVIVEKATCTS Cognizant replied to DhivyaDJHi, 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.