Last activity: 5 Mar 2019 5:42 EST
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.