SET_TO_TIMESTAMP stored procedure

The SET_TO_TIMESTAMP stored procedure is used to set the current snapshot of a Datalake Iceberg table to a specific snapshot taken before the specified timestamp. The snapshot the table is to be set to can be any snapshot.

Syntax

Read syntax diagramSkip visual syntax diagramSET_TO_TIMESTAMP(schema,table name, timestamp)

Description

'schema'
An input argument that specifies the Datalake Iceberg table schema name.
'table name'
The name of the Iceberg table whose state is to be set to.
'timestamp'
The timestamp that represents the point in time the table should be set to. The timestamp must be formatted as yyyy-MM-dd HH:mm:ss.SSS.
'message'
Message indicating the success or failure of the procedure. The message includes the timestamp the table was rolled back to. If the procedure failed, the message includes an explanation indicating why it failed.

Authorization

Execution of the SET_TO_TIMESTAMP stored procedure is restricted to users with Db2 administrative privileges.