Skip to content

/AWS1/CL_RSDEXECUTESTMTOUTPUT

ExecuteStatementOutput

CONSTRUCTOR

IMPORTING

Optional arguments:

IV_ID TYPE /AWS1/RSDUUID /AWS1/RSDUUID

The identifier of the SQL statement whose results are to be fetched. This value is a universally unique identifier (UUID) generated by Amazon Redshift Data API.

IV_CREATEDAT TYPE /AWS1/RSDTIMESTAMP /AWS1/RSDTIMESTAMP

The date and time (UTC) the statement was created.

IV_CLUSTERIDENTIFIER TYPE /AWS1/RSDCLUSTERIDSTRING /AWS1/RSDCLUSTERIDSTRING

The cluster identifier. This element is not returned when connecting to a serverless workgroup.

IV_DBUSER TYPE /AWS1/RSDSTRING /AWS1/RSDSTRING

The database user name.

IT_DBGROUPS TYPE /AWS1/CL_RSDDBGROUPLIST_W=>TT_DBGROUPLIST TT_DBGROUPLIST

A list of colon (:) separated names of database groups.

IV_DATABASE TYPE /AWS1/RSDSTRING /AWS1/RSDSTRING

The name of the database.

IV_SECRETARN TYPE /AWS1/RSDSECRETARN /AWS1/RSDSECRETARN

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

IV_WORKGROUPNAME TYPE /AWS1/RSDWORKGROUPNAMESTRING /AWS1/RSDWORKGROUPNAMESTRING

The serverless workgroup name or Amazon Resource Name (ARN). This element is not returned when connecting to a provisioned cluster.

IV_SESSIONID TYPE /AWS1/RSDUUID /AWS1/RSDUUID

The session identifier of the query.


Queryable Attributes

Id

The identifier of the SQL statement whose results are to be fetched. This value is a universally unique identifier (UUID) generated by Amazon Redshift Data API.

Accessible with the following methods

Method Description
GET_ID() Getter for ID, with configurable default
ASK_ID() Getter for ID w/ exceptions if field has no value
HAS_ID() Determine if ID has a value

CreatedAt

The date and time (UTC) the statement was created.

Accessible with the following methods

Method Description
GET_CREATEDAT() Getter for CREATEDAT, with configurable default
ASK_CREATEDAT() Getter for CREATEDAT w/ exceptions if field has no value
HAS_CREATEDAT() Determine if CREATEDAT has a value

ClusterIdentifier

The cluster identifier. This element is not returned when connecting to a serverless workgroup.

Accessible with the following methods

Method Description
GET_CLUSTERIDENTIFIER() Getter for CLUSTERIDENTIFIER, with configurable default
ASK_CLUSTERIDENTIFIER() Getter for CLUSTERIDENTIFIER w/ exceptions if field has no v
HAS_CLUSTERIDENTIFIER() Determine if CLUSTERIDENTIFIER has a value

DbUser

The database user name.

Accessible with the following methods

Method Description
GET_DBUSER() Getter for DBUSER, with configurable default
ASK_DBUSER() Getter for DBUSER w/ exceptions if field has no value
HAS_DBUSER() Determine if DBUSER has a value

DbGroups

A list of colon (:) separated names of database groups.

Accessible with the following methods

Method Description
GET_DBGROUPS() Getter for DBGROUPS, with configurable default
ASK_DBGROUPS() Getter for DBGROUPS w/ exceptions if field has no value
HAS_DBGROUPS() Determine if DBGROUPS has a value

Database

The name of the database.

Accessible with the following methods

Method Description
GET_DATABASE() Getter for DATABASE, with configurable default
ASK_DATABASE() Getter for DATABASE w/ exceptions if field has no value
HAS_DATABASE() Determine if DATABASE has a value

SecretArn

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

Accessible with the following methods

Method Description
GET_SECRETARN() Getter for SECRETARN, with configurable default
ASK_SECRETARN() Getter for SECRETARN w/ exceptions if field has no value
HAS_SECRETARN() Determine if SECRETARN has a value

WorkgroupName

The serverless workgroup name or Amazon Resource Name (ARN). This element is not returned when connecting to a provisioned cluster.

Accessible with the following methods

Method Description
GET_WORKGROUPNAME() Getter for WORKGROUPNAME, with configurable default
ASK_WORKGROUPNAME() Getter for WORKGROUPNAME w/ exceptions if field has no value
HAS_WORKGROUPNAME() Determine if WORKGROUPNAME has a value

SessionId

The session identifier of the query.

Accessible with the following methods

Method Description
GET_SESSIONID() Getter for SESSIONID, with configurable default
ASK_SESSIONID() Getter for SESSIONID w/ exceptions if field has no value
HAS_SESSIONID() Determine if SESSIONID has a value