dbSendMultiUpdate: Run multiple SQL query actions within the DB environment.

In SQLove: Execute 'SQL' Scripts in 'R' Containing Multiple Queries

Run multiple SQL query actions within the DB environment.

Description

Requires a DBI workflow that creates a connection with a relational database per DBI: https://dbi.r-dbi.org/. This function is an extension of the RJDBC::dbSendUpdate function.

Usage

dbSendMultiUpdate(conn, conn_type = "JDBC", sql_path)

Arguments

conn	A database connection object
conn_type	A string indicating if the connection type is a JDBC or ODBC connection - accepts "JDBC" or "ODBC" as arguments, defaults to "JDBC"
sql_path	Character vector pointing to SQL script

Value

No object returned - for production automation

SQLove documentation built on June 8, 2025, 1:09 p.m.