Question
3
Replies
2069
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
Moderation Team has archived post,
Close popover
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: 4 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: 4 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.