/AWS1/CL_RDDEXECUTESTMTRSP¶
The response elements represent the output of a request to run a SQL statement against a database.
CONSTRUCTOR¶
IMPORTING¶
Optional arguments:¶
it_records TYPE /AWS1/CL_RDDFIELD=>TT_SQLRECORDS TT_SQLRECORDS¶
The records returned by the SQL statement. This field is blank if the
formatRecordsAsparameter is set toJSON.
it_columnmetadata TYPE /AWS1/CL_RDDCOLUMNMETADATA=>TT_METADATA TT_METADATA¶
Metadata for the columns included in the results. This field is blank if the
formatRecordsAsparameter is set toJSON.
iv_numberofrecordsupdated TYPE /AWS1/RDDRECORDSUPDATED /AWS1/RDDRECORDSUPDATED¶
The number of records updated by the request.
it_generatedfields TYPE /AWS1/CL_RDDFIELD=>TT_FIELDLIST TT_FIELDLIST¶
Values for fields generated during a DML request.
The
generatedFieldsdata isn't supported by Aurora PostgreSQL. To get the values of generated fields, use theRETURNINGclause. For more information, see Returning Data From Modified Rows in the PostgreSQL documentation.
iv_formattedrecords TYPE /AWS1/RDDFORMATTEDSQLRECORDS /AWS1/RDDFORMATTEDSQLRECORDS¶
A string value that represents the result set of a
SELECTstatement in JSON format. This value is only present when theformatRecordsAsparameter is set toJSON.The size limit for this field is currently 10 MB. If the JSON-formatted string representing the result set requires more than 10 MB, the call returns an error.
Queryable Attributes¶
records¶
The records returned by the SQL statement. This field is blank if the
formatRecordsAsparameter is set toJSON.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_RECORDS() |
Getter for RECORDS, with configurable default |
ASK_RECORDS() |
Getter for RECORDS w/ exceptions if field has no value |
HAS_RECORDS() |
Determine if RECORDS has a value |
columnMetadata¶
Metadata for the columns included in the results. This field is blank if the
formatRecordsAsparameter is set toJSON.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_COLUMNMETADATA() |
Getter for COLUMNMETADATA, with configurable default |
ASK_COLUMNMETADATA() |
Getter for COLUMNMETADATA w/ exceptions if field has no valu |
HAS_COLUMNMETADATA() |
Determine if COLUMNMETADATA has a value |
numberOfRecordsUpdated¶
The number of records updated by the request.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_NUMBEROFRECORDSUPDATED() |
Getter for NUMBEROFRECORDSUPDATED |
generatedFields¶
Values for fields generated during a DML request.
The
generatedFieldsdata isn't supported by Aurora PostgreSQL. To get the values of generated fields, use theRETURNINGclause. For more information, see Returning Data From Modified Rows in the PostgreSQL documentation.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_GENERATEDFIELDS() |
Getter for GENERATEDFIELDS, with configurable default |
ASK_GENERATEDFIELDS() |
Getter for GENERATEDFIELDS w/ exceptions if field has no val |
HAS_GENERATEDFIELDS() |
Determine if GENERATEDFIELDS has a value |
formattedRecords¶
A string value that represents the result set of a
SELECTstatement in JSON format. This value is only present when theformatRecordsAsparameter is set toJSON.The size limit for this field is currently 10 MB. If the JSON-formatted string representing the result set requires more than 10 MB, the call returns an error.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_FORMATTEDRECORDS() |
Getter for FORMATTEDRECORDS, with configurable default |
ASK_FORMATTEDRECORDS() |
Getter for FORMATTEDRECORDS w/ exceptions if field has no va |
HAS_FORMATTEDRECORDS() |
Determine if FORMATTEDRECORDS has a value |