Question
Coforge
US
Last activity: 25 Aug 2020 14:35 EDT
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
|
TCS
IN
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}
Coforge
US
I have tried the same But, Getting other error. Error Code -199
UPDATE tablename
SET
Column1 = Value1,
Column2 = Value2
WHERE
( Column1 = ''
and Column2 = ''
and Column3 = 'NEW' ) ROWs < {DSS Value}
|
TCS
IN
Hi jalander,
could you try this
UPDATE tablename SET Column1 = Value1, Column2 = Value2 WHERE Column1 IS NULL and Column2 IS NULL and Column3 = 'NEW' ROWNUM < {DSS Value}
IN SQL it is best practice to use IS NULL to refer null value in table