[Openroad-users] Conversion to OpenSQL

[Paul White]

When we enhanced our apps to support ea/mssql, we had to modify the
syntax for UPDATE FROM using execute immediate.

If ingresdb then
 UPDATE mytable 
 FROM othertable
 SET myfield = otherfield
 WHERE mykey = otherkey;

else
 lv_sql =	' UPDATE mytable ' +
		' SET myfield = otherfield ' +
		' FROM othertable ' +
		' WHERE mykey = otherkey'
 EXECUTE IMMEDIATE lv_sql;

Chris Clark wrote
    * UPDATE <table> FROM -- Not OpenSQL, you _may_ be able to do some
      host specific via *DIRECT* EXECUTE IMMEDIATE