NAME

Paws::RDSData::BatchExecuteStatement - Arguments for method BatchExecuteStatement on Paws::RDSData

DESCRIPTION

This class represents the parameters used for calling the method BatchExecuteStatement on the AWS RDS DataService service. Use the attributes of this class as arguments to method BatchExecuteStatement.

You shouldn't make instances of this class. Each attribute should be used as a named argument in the call to BatchExecuteStatement.

SYNOPSIS

my $rds-data = Paws->service('RDSData');
my $BatchExecuteStatementResponse = $rds -data->BatchExecuteStatement(
  ResourceArn   => 'MyArn',
  SecretArn     => 'MyArn',
  Sql           => 'MySqlStatement',
  Database      => 'MyDbName',         # OPTIONAL
  ParameterSets => [
    [
      {
        Name     => 'MyParameterName',    # OPTIONAL
        TypeHint => 'JSON'
        ,    # values: JSON, UUID, TIMESTAMP, DATE, TIME, DECIMAL; OPTIONAL
        Value => {
          ArrayValue => {
            ArrayValues   => [ <ArrayValue>, ... ],    # OPTIONAL
            BooleanValues => [ 1,            ... ],    # OPTIONAL
            DoubleValues  => [ 1,            ... ],    # OPTIONAL
            LongValues    => [ 1,            ... ],    # OPTIONAL
            StringValues  => [ 'MyString',   ... ],    # OPTIONAL
          },    # OPTIONAL
          BlobValue    => 'BlobBlob',    # OPTIONAL
          BooleanValue => 1,
          DoubleValue  => 1,
          IsNull       => 1,
          LongValue    => 1,
          StringValue  => 'MyString',
        },    # OPTIONAL
      },
      ...
    ],
    ...
  ],    # OPTIONAL
  Schema        => 'MyDbName',    # OPTIONAL
  TransactionId => 'MyId',        # OPTIONAL
);

# Results:
my $UpdateResults = $BatchExecuteStatementResponse->UpdateResults;

# Returns a L<Paws::RDSData::BatchExecuteStatementResponse> object.

Values for attributes that are native types (Int, String, Float, etc) can passed as-is (scalar values). Values for complex Types (objects) can be passed as a HashRef. The keys and values of the hashref will be used to instance the underlying object. For the AWS API documentation, see https://docs.aws.amazon.com/goto/WebAPI/rds-data/BatchExecuteStatement

ATTRIBUTES

Database => Str

The name of the database.

ParameterSets => ArrayRef[ArrayRef[Paws::RDSData::SqlParameter]]

The parameter set for the batch operation.

The SQL statement is executed as many times as the number of parameter sets provided. To execute a SQL statement with no parameters, use one of the following options:

• Specify one or more empty parameter sets.

• Use the ExecuteStatement operation instead of the BatchExecuteStatement operation.

Array parameters are not supported.

REQUIRED ResourceArn => Str

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

Schema => Str

The name of the database schema.

REQUIRED SecretArn => Str

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

REQUIRED Sql => Str

The SQL statement to run.

TransactionId => Str

The identifier of a transaction that was started by using the BeginTransaction operation. Specify the transaction ID of the transaction that you want to include the SQL statement in.

If the SQL statement is not part of a transaction, don't set this parameter.

SEE ALSO

This class forms part of Paws, documenting arguments for method BatchExecuteStatement in Paws::RDSData

BUGS and CONTRIBUTIONS

The source code is located here: https://github.com/pplu/aws-sdk-perl

Please report bugs to: https://github.com/pplu/aws-sdk-perl/issues

cpanm Paws

perl -MCPAN -e shell
install Paws