Skip to content

/AWS1/IF_RSS=>RESTORETABLEFROMRECPOINT()

About RestoreTableFromRecoveryPoint

Restores a table from a recovery point to your Amazon Redshift Serverless instance. You can't use this operation to restore tables with interleaved sort keys.

Method Signature

METHODS /AWS1/IF_RSS~RESTORETABLEFROMRECPOINT
  IMPORTING
    !IV_NAMESPACENAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_WORKGROUPNAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_RECOVERYPOINTID TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_SOURCEDATABASENAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_SOURCESCHEMANAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_SOURCETABLENAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_TARGETDATABASENAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_TARGETSCHEMANAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_NEWTABLENAME TYPE /AWS1/RSSSTRING OPTIONAL
    !IV_ACTIVATECASESENSITIVEID TYPE /AWS1/RSSBOOLEAN OPTIONAL
  RETURNING
    VALUE(OO_OUTPUT) TYPE REF TO /aws1/cl_rssrestoretblfrmrec01
  RAISING
    /AWS1/CX_RSSCONFLICTEXCEPTION
    /AWS1/CX_RSSINTERNALSERVEREX
    /AWS1/CX_RSSRESOURCENOTFOUNDEX
    /AWS1/CX_RSSVALIDATIONEX
    /AWS1/CX_RSSCLIENTEXC
    /AWS1/CX_RSSSERVEREXC
    /AWS1/CX_RT_TECHNICAL_GENERIC
    /AWS1/CX_RT_SERVICE_GENERIC.

IMPORTING

Required arguments:

iv_namespacename TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

Namespace of the recovery point to restore from.

iv_workgroupname TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The workgroup to restore the table to.

iv_recoverypointid TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The ID of the recovery point to restore the table from.

iv_sourcedatabasename TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the source database that contains the table being restored.

iv_sourcetablename TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the source table being restored.

iv_newtablename TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the table to create from the restore operation.

Optional arguments:

iv_sourceschemaname TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the source schema that contains the table being restored.

iv_targetdatabasename TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the database to restore the table to.

iv_targetschemaname TYPE /AWS1/RSSSTRING /AWS1/RSSSTRING

The name of the schema to restore the table to.

iv_activatecasesensitiveid TYPE /AWS1/RSSBOOLEAN /AWS1/RSSBOOLEAN

Indicates whether name identifiers for database, schema, and table are case sensitive. If true, the names are case sensitive. If false, the names are not case sensitive. The default is false.

RETURNING

oo_output TYPE REF TO /aws1/cl_rssrestoretblfrmrec01 /AWS1/CL_RSSRESTORETBLFRMREC01

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->restoretablefromrecpoint(
  iv_activatecasesensitiveid = ABAP_TRUE
  iv_namespacename = |string|
  iv_newtablename = |string|
  iv_recoverypointid = |string|
  iv_sourcedatabasename = |string|
  iv_sourceschemaname = |string|
  iv_sourcetablename = |string|
  iv_targetdatabasename = |string|
  iv_targetschemaname = |string|
  iv_workgroupname = |string|
).

This is an example of reading all possible response values

lo_result = lo_result.
IF lo_result IS NOT INITIAL.
  lo_tablerestorestatus = lo_result->get_tablerestorestatus( ).
  IF lo_tablerestorestatus IS NOT INITIAL.
    lv_string = lo_tablerestorestatus->get_tablerestorerequestid( ).
    lv_string = lo_tablerestorestatus->get_status( ).
    lv_string = lo_tablerestorestatus->get_message( ).
    lv_timestamp = lo_tablerestorestatus->get_requesttime( ).
    lv_string = lo_tablerestorestatus->get_namespacename( ).
    lv_string = lo_tablerestorestatus->get_workgroupname( ).
    lv_string = lo_tablerestorestatus->get_snapshotname( ).
    lv_long = lo_tablerestorestatus->get_progressinmegabytes( ).
    lv_long = lo_tablerestorestatus->get_totaldatainmegabytes( ).
    lv_string = lo_tablerestorestatus->get_sourcedatabasename( ).
    lv_string = lo_tablerestorestatus->get_sourceschemaname( ).
    lv_string = lo_tablerestorestatus->get_sourcetablename( ).
    lv_string = lo_tablerestorestatus->get_targetdatabasename( ).
    lv_string = lo_tablerestorestatus->get_targetschemaname( ).
    lv_string = lo_tablerestorestatus->get_newtablename( ).
    lv_string = lo_tablerestorestatus->get_recoverypointid( ).
  ENDIF.
ENDIF.