REGISTER_EXT_METASTORE stored procedure

The SYSHADOOP. REGISTER_EXT_METASTORE stored procedure registers an external watsonx.data metastore in Db2 for the purpose of sharing metadata (and data) between the watsonx.data system and Db2. For more information, see Accessing watsonx.data.

Authorization

EXECUTE is granted to the DASHDB_ENTERPRISE_ADMIN role.

Syntax

Read syntax diagramSkip visual syntax diagramREGISTER_EXT_METASTORE('external-metastore-name' ,'properties','status-code','status-message')

The schema is SYSHADOOP.

Description

'external-metastore-name'
An input argument of type VARCHAR(256) indicating the name under which the metastore is to be registered.
'properties'
An input argument of type VARCHAR(32672) providing a comma separated list of configuration property names and values (the name and value must be separated by a single ‘=’ sign) for the metastore. For a list of supported properties, see SET_EXT_METASTORE_PROPERTY stored procedure.
'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.REGISTER_EXT_METASTORE('watsonxdata', 'type=watsonx-data,uri=thrift://watsonx.data.ibm.com:9083', ?, ?)