UNREGISTER_EXT_METASTORE stored procedure

The SYSHADOOP. UNREGISTER_EXT_METASTORE unregisters a registered external watsonx.data metastore from Db2.

After the metastore is unregistered, it is not possible to import tables from it. In addition, it is not possible to use Iceberg tables imported from the watsonx.data systems or created in it from Db2 any more.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagramUNREGISTER_EXT_METASTORE(metastore_name ,status_code,status_message)

The schema is SYSHADOOP.

Description

metastore_name
An input argument of type VARCHAR(256) indicating the name of the registered external metastore to unregister.
status_code
An output argument of type INTEGER indicating whether the operation was successful. 0 indicates success, a non-zero value indicates an error.
status_message
An output argument of type VARCHAR(1024) indicating whether the operation was successful.

Examples

CALL SYSHADOOP.UNREGISTER_EXT_METASTORE('watsonxdata', ?, ?)