AnsweredAssumed Answered

Error executing SQL statement using Program Command Shape

Question asked by SaiKumarGoud Mallari on Aug 10, 2018
Latest reply on Aug 13, 2018 by kartikay.nagal147205

I have an SQL statement which requires a run time parameter ,which is throwing  an error every time i try to pass a parameter using variables.

SQL Statement formed(From Logs ):Executing SQL delete from tivo_watchhistory_start where boomiupdateflag is NOT NULL and datecreated='2018-07-28 00:00:00' 
But here in the logs  the SQL statement looks perfectly good and is as expected.

2. And when i set parameter value directly in the statement,process executes without any errors.

SQL Statement formed(From Logs ):Executing SQL delete from tivo_watchhistory_start where boomiupdateflag is NOT NULL and datecreated='2018-07-28 00:00:00'

Any suggestions on why this would happen?

Outcomes