IDAX.PREDICT_GLM - Apply a generalized linear model (GLM)

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role. Additionally, you must be the owner of the model or have the authority to alter it.

Syntax

IDAX.PREDICT_GLM(in parameter_string varchar(32672), in synchronous boolean default true)

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 generalized linear model that is to be built.

Data type: VARCHAR(64)

intable

Mandatory.

The name of the input table.

Data type: VARCHAR(128)

outtable

Mandatory.

The name of the output table where the predictions are stored.

Data type: VARCHAR(128)

id

Optional.

The column of the input table that identifies a unique instance ID.

Default: The name of the id column that is used to build the model.

Data type: VARCHAR(128)

debug

Optional.

A flag that indicates whether debug information is to be shown.

Default: false

Data type: BOOLEAN

synchronous

Optional.

Synchronous or asynchronous execution of the PREDICT_GLM stored procedure.

In a synchronous execution, the PREDICT_GLM stored procedure waits until the execution is completed. In an asynchronous execution, the PREDICT_GLM procedure returns as soon as it is submitted.

To get the status and the submission ID of an asynchronously executed PREDICT_GLM stored procedure, call the IDAX.APP_STATUS() stored procedure after you launch the PREDICT_GLM stored procedure.

To cancel an asynchronously executed PREDICT_GLM stored procedure, call the IDAX.CANCEL_APP() stored procedure while the PREDICT_GLM stored procedure is running.

Default: true

Returned information

The procedure does not return any SQL results.

Example

CALL IDAX.PREDICT_GLM('model=adult_mdl, intable=adult_test, id=id, outtable=adult_mdl_score');