skip to main content
Using the Driver : Parameter Metadata Support : Insert, Update, and Delete Statements
  

Try DataDirect Drivers Now

Insert, Update, and Delete Statements

The driver supports returning parameter metadata for the following forms of Insert, Update, and Delete statements 1 :
*INSERT INTO foo VALUES (?, ?, ?)
*INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?)
*UPDATE foo SET col1=?, col2=?, col3=? WHERE col1 operator  ? [{AND | OR} col2  operator ?]
*DELETE FROM foo WHERE col1 operator ?
where operator is any of the following SQL operators: =, <, >, <=, >=, and <>.
1 While the driver supports returning parameter metadata for these statements, the SQL commands themselves may not be supported for some versions of Apache Spark SQL.