Learn R Programming

paws.database (version 0.1.12)

rdsdataservice_begin_transaction: Starts a SQL transaction

Description

Starts a SQL transaction.

 <important> <p>A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours.</p> <p>A transaction times out if no calls use its transaction ID in three minutes. If a transaction times out before it's committed, it's rolled back automatically.</p> <p>DDL statements inside a transaction cause an implicit commit. We recommend that you run each DDL statement in a separate <code>ExecuteStatement</code> call with <code>continueAfterTimeout</code> enabled.</p> </important> 

Usage

rdsdataservice_begin_transaction(database, resourceArn, schema,
  secretArn)

Value

A list with the following syntax:

list(
  transactionId = "string"
)

Arguments

database

The name of the database.

resourceArn

[required] The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.

schema

The name of the database schema.

secretArn

[required] The name or ARN of the secret that enables access to the DB cluster.

Request syntax

svc$begin_transaction(
  database = "string",
  resourceArn = "string",
  schema = "string",
  secretArn = "string"
)