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?
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.
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.
Hello,
I'm not sure to get the question. Can you just add your RDB method on step 4 with a WHEN condition?