Question

2
Replies
64
Views
ABHISHEKSINHA Member since 2013 10 posts
HSBC
Posted: 2 years ago
Last activity: 1 year 7 months ago
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.

Moderation Team has archived post
Share this page LinkedIn