Question
SINARMASMSIGLIFE
SINARMASMSIGLIFE
ID
SINARMASMSIGLIFE
Posted: Apr 28, 2017
Last activity: May 9, 2017
Last activity: 9 May 2017 23:17 EDT
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
Accepted Solution
Posted: 7 years ago
SINARMASMSIGLIFE
SINARMASMSIGLIFE
ID
I use double qoute on sql statement for this ISSUE.
for example :
select a from table b where a.ax = (''\\asd'')
thanks
Posted: 7 years ago
PEGA
Pegasystems Inc.
IN
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.
Posted: 7 years ago
SINARMASMSIGLIFE
SINARMASMSIGLIFE
ID
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.
To see attachments, please log in.
Accepted Solution
Posted: 7 years ago
SINARMASMSIGLIFE
SINARMASMSIGLIFE
ID
I use double qoute on sql statement for this ISSUE.
for example :
select a from table b where a.ax = (''\\asd'')
thanks