Discussion

2
Replies
563
Views
SUDEERKUMAR Member since 2010 9 posts
CapitalOne
Posted: 5 years ago
Last activity: 4 years 11 months ago
Closed

Invalid character error while executing RDB-LIST

Table :

Brand1 model1 date1

Brand1 model2 date2

Brand1 model3 date3

Brand2 model1 date1

Brand2 model2 date2

 

I need to get Brand1 model3 date3

                     Brand2 model2 date2

Distinct brand with latest updated date.

 

to achieve this i written below  sql script which is wokring fine if I run it in Sql Developer but when run the query from pega throwing error as invalid character.

I dont see any error in th e syntax , if anyone finds please let me know.

 

SELECT BRANDCODE as ".Brandcode" , PXUPDATEDATE AS ".pxUpdateDateTime"  FROM 

(SELECT BRANDCODE ,BRAND,PXUPDATEDATETIME,ROW_NUMBER() OVER (PARTITION BY BRANDCODE ORDER BY PXUPDATEDATETIME DESC) AS Num

FROM {class:SCB-Data-BrandModel} WHERE STATUS='1' AND APPLICATIONTYPE='Auto' ) WHERE Num = 1;

Data Integration
Moderation Team has archived post
Share this page LinkedIn