IDAX.PREDICT_LINEAR_REGRESSION - Apply a linear regression model to a target

Use this stored procedure to apply a linear regression model to a target.

Authorities

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 SELECT privilege on the source model.

Syntax

IDAX.PREDICT_LINEAR_REGRESSION(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 linear regression model that is to be applied.; Data type: VARCHAR(64)
id: Mandatory.; The column of the input table that identifies a unique instance.; Data type: VARCHAR(128)
intable: Mandatory.; The name of the input table.; Data type: VARCHAR(128)
outtable: The name of the output table where the prediction for the target column is stored.; Data type: VARCHAR(128)

Returned information

If the PREDICT_LINEAR_REGRESSION stored procedure is completed successfully, the following string as a result set, where t means true.

Result set 1
  --------------

  PREDICT_LINEAR_REGRESSION
  -------------------------
  t                

  1 record(s) selected.

  Return Status = 0

Example

CALL IDAX.PREDICT_LINEAR_REGRESSION('model=adult_linreg, intable=adult_score, outtable=adult_results, id=id');