IDAX.MODEL_EXISTS - Determine whether a model exists

Use this stored procedure to determine whether a model with the specified name exists.

Authorization

None required.

Syntax

IDAX.MODEL_EXISTS(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 determined.
You can qualify the value of the model parameter with a schema name as follows:
<schema name>.<model name>
exception
Optional.
Default: false
If exception=true is specified, an exception is raised if the model does not exist.
inverse
Optional.
Default: false
If inverse=true is specified, the exception logic is reversed, that is, an exception is raised if the model exists.

Returned information

Return code 1
1 is returned if a model exists.
Return code 0
0 is returned if no model exists.

Example

CALL IDAX.MODEL_EXISTS('model=cc_nb_ewd');