Progress DataDirect for JDBC for Apache Spark SQL User's Guide Release 6.0.1

Insert, Update, and Delete Statements

Save PDF

Table of Contents

Insert, Update, and Delete Statements

Save PDF

Last Updated: March 7, 2016
1 minute read

DataDirect Connectors
JDBC
Apache Spark SQL 6.0
Documentation

The driver supports returning parameter metadata for the following forms of Insert, Update, and Delete statements ¹ :

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 <>.

¹ 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.