IDAX.COPY_MODEL - Duplicate a model

Use this stored procedure to duplicate a model, its managed components, and the metadata from the same schema or from another schema. Thus, you can exchange a model with other users within the same database.

The session user is the owner of the copied model.

Prerequisites

You can copy a model only if the state of the model is Complete.

Authorities

The privileges held by the authorization ID of the statement must include at least one of the following authorities:

SELECT privilege on the source model
DATAACCESS authority

Syntax

IDAX.COPY_MODEL(in parameter_string varchar(32672))

Parameter descriptions

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

model

Mandatory.

The name of the model that is to be copied.

You can qualify the value of the model parameter with a schema name as follows:

<schema name>.<model name>

copy

Mandatory.

The name of the new model.

You can qualify the value of the model parameter with a schema name as follows:

<schema name>.<model name>

Returned information

If an error occurs, an exception is raised.

Example

CALL IDAX.COPY_MODEL('model=cc_nb_ewd, copy=cc_nb_ewd_copy');