Hi I am working to connect with DB2 in the IBM cloud through Mendix using database connector for delete and update operation in tables. However, I’m facing a connector error in the SQL statement. My SQL syntax is below for both the operations. 'DELETE FROM EMPLOYEE WHERE NAME='+ $EMPLOYEE/NAME+';' 'UPDATE EMPLOYEE SET NAME='''+ $EMPLOYEE/NAME +''', WHERE REG='+ $EMPLOYEE/REG+';' Please help me to resolve it
what does the error says?
try with a simpler sql request to see if the problem come from your request, or from something else.