Question

3
Replies
2101
Views
 Ryan Fauzan (RyanLoatoz)
SINARMASMSIGLIFE
System Architect & Digital Solution
SINARMASMSIGLIFE
ID
RyanLoatoz Member since 2016 36 posts
SINARMASMSIGLIFE
Posted: April 28, 2017
Last activity: May 9, 2017
Posted: 28 Apr 2017 11:08 EDT
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

Low-Code App Development Data Integration
Moderation Team has archived post, 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
Posted: 28 Apr 2017 16:40 EDT
Sai Boyana (boyas)
PEGA
Principal Technical Solutions Engineer
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: 4 years ago
Posted: 29 Apr 2017 11:26 EDT
Ryan Fauzan (RyanLoatoz)
SINARMASMSIGLIFE
System Architect & Digital Solution
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.

Accepted Solution

Posted: 4 years ago
Posted: 9 May 2017 23:17 EDT
Ryan Fauzan (RyanLoatoz)
SINARMASMSIGLIFE
System Architect & Digital Solution
SINARMASMSIGLIFE
ID
I use double qoute on sql statement for this ISSUE.


 


for example :


select a from table b where a.ax = (''\\asd'')


 


thanks