IDAX.PMML_MODEL - Create a PMML representation of a model

Use this stored procedure to create a PMML document of an analytic model and store this document in a table.

Prerequisites

A model must be in the state 'complete' before it can be converted to PMML.

The PMML function is not available for all algorithms

Authorization

The privileges held by the authorization ID of the statement must include the SELECT privilege on the model that is to be stored as a PMML model.

Syntax

IDAX.PMML_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 stored as a PMML model.
Data type: VARCHAR(64)
type
Optional.
The type of PMML model that is to be created.
Allowed values are 'standard' and 'spss'.
Default: standard
Data type: VARCHAR(16)
outtable
Optional.
The name of the output table into which the PMML model is written.
The specified output table can be a new table or an existing table.
Data type: VARCHAR(128)

Returned information

INTEGER the number of records that are written into the PMML table.

Example

CALL IDAX.PMML_MODEL('model=cc_nb_ewd,outtable=pmmlmodels');