REMOVE_TAG stored procedure

The REMOVE_TAG stored procedure is used to remove a tag reference from a Datalake Iceberg table.

The tags and branches defined for a table can be queried using the TABLE_SNAPSHOT_REFS table function.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagramCREATE_TAG(schema_name ,table_name,tag)

The schema is SYSHADOOP.

Description

schema_name
An input argument of type VARCHAR(128) containing the name of the schema. This is a required parameter which identifies the schema name. Although this can be specified using the named parameter syntax, it is not recommended.
table_name
An input argument of type VARCHAR(128) containing the name of the table. This is a required parameter which references the table which will be impacted by the procedure. Although this can be specified using the named parameter syntax, it is not recommended.
tag
An input parameter of type VARCHAR(32672) which specifies the tag name to be removed. This parameter is required.

Output

A result set with two columns named STATUS_CODE and STATUS_MESSAGE. These columns contain values indicating the success or failure of the procedure. If the procedure succeeds, the STATUS_CODE is set to 0 and the STATUS_MESSAGE includes information related to the procedure results. If the procedure failed, the STATUS_CODE is set to -1 and the STATUS_MESSAGE includes an explanation indicating why it failed.

Example

CALL REMOVE_TAG('SAMPLE', 'EMPLOYEE', 'release_one')      

  Result set 1

  --------------

  STATUS_CODE STATUS_MESSAGE                                    

  ----------- --------------------------------------------------

            0 Tag release_one removed from table SAMPLE.EMPLOYEE

  1 record(s) selected.

  Return Status = 0