Question
3
Replies
2014
Views
SINARMASMSIGLIFE
Posted: April 28, 2017
Last activity: May 9, 2017
Closed
Solved
Update Statement SQL using CONNECT-SQL
hi,
I want to ask if the Pega can do update statement SQL query in Connect SQL?
because I read in /prhelp/rule-/rule-connect-/rule-connect-sql/save.htm describe it can be use it.
i tried to use update statement query in tab save but getting error..
can anyone help me.
thanks
Posted: 3 years ago
Hi boyas,
I can't get the logs because i'm not the administrator server . But i can request it later.
Whether the query statement in the save tab can read characters like '/'?
When I put these characters and i click test , i get some error As I screenshot.
Accepted Solution
Posted: 3 years ago
I use double qoute on sql statement for this ISSUE.
for example :
select a from table b where a.ax = (''\\asd'')
thanks
Hi Ryan,
Connect-SQL should work for update Sql statement.
However,attaching the PegaRule and PegaAlert logs when Connect-SQL ran should have some details.
Can you attach the logs.