The EXECUTE command is used to run an SQL statement against the remote database. There are four types of execution modes:
SQL Command Escaping
There will be issues with brackets, single and double quotes in your literal SQL statements.
You need to consider escaping and protecting the SQL command keyword values. For example, the single quote required by the SQL command syntax might conflict with the single quote required by the RDML language to create the command string:
EXECUTE UPDATE(UPDATE TABLE SET COL1='value')
EXECUTE UPDATE(DELETE FROM TABLE WHERE COL1='value')
If your SQL statement contains open or closed brackets, you will need to include double quotes around the entire statement. For example:
EXECUTE PREPARED("INSERT INTO TABLE (COL1,COL2,COL3) VALUES(?,?,?)")
