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

 ABHISHEK SINHA (ABHISHEKSINHA)
HSBC
ABHISHEK SINHA
HSBC
IN
ABHISHEKSINHA Member since 2013 10 posts
HSBC
Posted: May 1, 2018
Last activity: Mar 5, 2019
Posted: 1 May 2018 5:31 EDT
Last activity: 5 Mar 2019 5:42 EST
Closed

Unable to update PYLASTUPDATEDATE of pr_extract_time table through Connect-SQL

Getting invalid character error while updating the pr_extract_time column PYLASTUPDATEDATE. Below are the post-sql query.

SQL Query : UPDATE CDS.pr_extract_time SET PYLASTUPDATEDATE = '02-MAY-18' WHERE PYINSNAME like '%BIX_COAST_AGN%'; commit;

Note : The above query is runs fine in SQL developer but throwing error in Connect-SQL.

To see attachments, please log in.

Posted: 5 years ago
Posted: 5 Mar 2019 5:42 EST
lakshmi sravanya chittajallu (lakshmisravanyac7719)
Areteans Technologies

Areteans Technologies
IN

Hi Abhishek,

Can you please post the query that is being formed when you are trying to run the query from Connect-SQL to understand the scenario better.

Thanks.

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