Question
3
Replies
55
Views
TCS
Posted: August 19, 2020
Last activity: August 25, 2020
Not able to update limited records in Connect-SQL
I Have tried to update Some Limited count of records through the Connect-SQL in Pega 6.2. But Getting below error.
I have used below Query in Save Tab.
UPDATE (SELECT * FROM {table name}
WHERE (Column1 = '' and Column2 = '' and Column3 = 'NEW') FETCH FIRST {DSS value} ROWs ONLY)
SET Column1 = V1, Column2 = V2
Please help on this
Thanks
|
Hi jalander,
i think query you have mentioned is not correct as per update syntax
update table set column=value where condition
you can restrict rows with rows<3 then it update only first 2 rows
UPDATE table name SET Column1 = V1, Column2 = V2
WHERE (Column1 = '' and Column2 = '' and Column3 = 'NEW') ROWs < {DSS value}