Multiple queries in single Connect-SQL rule
I want to run multiple distinct queries in a single Connect-SQL rule (for a single action type such as Delete). Is this possible?
I know the preferred method is using a Stored Procedure or distinct Connect-SQL rules but I'm wondering if what I want to do is possible.
Also, there's this old post for the same but the one and only "Accepted solution" is a broken link, so not super helpful.
https://collaborate.pega.com/question/multiple-inserts-connect-sql
Pegasystems Inc.
FR
Is this article helpful: https://community.pega.com/knowledgebase/articles/data-and-integration/how-return-multiple-resultsets-connect-sql-operations
Updated: 3 Feb 2021 11:02 EST
SkillStorm
US
No, I tried using the {multiset} keyword and toying with how to end the queries but no matter what I do I get the same error as without the tag.
There was a problem getting a list: code: 933 SQLState: 42000 Message: ORA-00933: SQL command not properly ended
You normally don't include the closing ; but I tried with and without that for each of the queries and only for the last one.
Pegasystems Inc.
FR
No I think you are right. Better to use two Connect-Sql or just one branch on a stored procedure.
Actually you don't want to configure something other complex. It will be more difficult to maintain by the development team.