Skip to content

/AWS1/CL_RDD=>BEGINTRANSACTION()

About BeginTransaction

Starts a SQL transaction.

A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours.

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.

For Aurora MySQL, DDL statements inside a transaction cause an implicit commit. We recommend that you run each MySQL DDL statement in a separate ExecuteStatement call with continueAfterTimeout enabled.

Method Signature

IMPORTING

Required arguments:

IV_RESOURCEARN TYPE /AWS1/RDDARN /AWS1/RDDARN

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

IV_SECRETARN TYPE /AWS1/RDDARN /AWS1/RDDARN

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

Optional arguments:

IV_DATABASE TYPE /AWS1/RDDDBNAME /AWS1/RDDDBNAME

The name of the database.

IV_SCHEMA TYPE /AWS1/RDDDBNAME /AWS1/RDDDBNAME

The name of the database schema.

RETURNING

OO_OUTPUT TYPE REF TO /AWS1/CL_RDDBEGINTRANSACTRSP /AWS1/CL_RDDBEGINTRANSACTRSP