Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Naveenkumar Reddy Kanamathareddy (NaveenK8RDY)
L&T Infotech
IN
NaveenK8RDY Member since 2015 1 post
Posted: Jan 3, 2019
Last activity: Jan 10, 2019
Posted: 3 Jan 2019 15:13 EST
Last activity: 10 Jan 2019 1:51 EST
Closed

Issue in calling DB Function from RDB methods

Hi,

I want to call DB function from RDB methods. Could you please help me with the details. I have to pass 2 params to the function to get the results .I am using the below query in RDB list for the same.

SELECT {all} FROM [pegaData].[Fn_CustomerData] ({ASIS:.CustName}, {ASIS.CustID});

Getting the issue as 

There was a problem getting a list: code: 0 SQLState: 42601 Message: ERROR: syntax error at or near "["

To see attachments, please log in.
Data Integration

Posted: 5 years ago
Posted: 9 Jan 2019 8:47 EST
Vipin Kumar (DHEER_GCS)
PEGA
Director, Technical Support, Cloud Service
Pegasystems Inc.
US

It seems the sql parser is complaining about square brackets around schema name or the table name. Try removing those one at a time.

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Jan 2019 1:51 EST
Upendhar Vanaparthy (Upendhar)
Accenture
Tech Lead
Accenture
SG

Hi,

Please use below query,

SELECT {all} FROM pegaData.Fn_CustomerData ('{ASIS:.CustName}', '{ASIS:.CustID}')

assuming CustName and CustID are the parameters.

Thanks

Upendhar V

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice