Question

3
Replies
55
Views
Close popover
Jalander Reddy Amandla (JalanderReddyA)
TCS

TCS
IN
JalanderReddyA Member since 2015 2 posts
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

 There was a problem getting a list: code: -104 SQLState: 42601 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=(; STATISTICS, DRIVER=3.62.73 

 

***Edited by Moderator Marissa to update Platform Capability tags****

Pega Platform 6.2 Data Integration