dbSendMultiUpdate

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.

The nature of working with structured query language ('SQL') scripts
efficiently often requires the creation of temporary tables and there
are few clean and simple 'R' 'SQL' execution approaches that allow
you to complete this kind of work with the 'R' environment. This
package seeks to give 'SQL' implementations in 'R' a little love
by deploying functions that allow you to deploy complex 'SQL'
scripts within a typical 'R' workflow.

Kerns Sam

SQLove

Execute 'SQL' Scripts in 'R' Containing Multiple Queries

dbSendMultiUpdate function

<dl><dt>connection</dt>
<dd>A database connection object</dd>
<dt>sql_file_path</dt>
<dd>Character vector pointing to SQL script</dd></dl>

Arguments

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

<dl>

<dt>connection</dt>
<dd>A database connection object</dd>


<dt>sql_file_path</dt>
<dd>Character vector pointing to SQL script</dd>

</dl>

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

Description

Usage

Value

Arguments