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`¶

Domain /AWS1/RT_ACCOUNT_ID

Primitive Type NUMC

Examples¶

Syntax Example¶

This is an example of the syntax for calling the method. It includes every possible argument and initializes every possible value. The data provided is not necessarily semantically accurate (for example the value "string" may be provided for something that is intended to be an instance ID, or in some cases two arguments may be mutually exclusive). The syntax shows the ABAP syntax for creating the various data structures.

DATA(lo_result) = lo_client->/aws1/if_rdd~begintransaction(
  iv_database = |string|
  iv_resourcearn = |string|
  iv_schema = |string|
  iv_secretarn = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lv_id = lo_result->get_transactionid( ).
ENDIF.

/AWS1/CL_RDD=>BEGINTRANSACTION()¶