In most cases, provide the same analytic
functions that are available in IBM PureData® System for
Analytics
Netezza®). For example, in most cases, a particular
Netezza analytic function has an equivalent
analytic function. In some cases, changes are required.
Compatibility matrix for IBM PureData System for Analytics (Netezza) built-in and analytic functions
The following tables identify the Netezza functions of
the corresponding category and, if ported to , the
corresponding functions. The tables also
show changes and limitations.
The categories and the corresponding functions are sorted alphabetically.
Association rules
Table 1. Functions for association rules
| Netezza function |
function |
Changes and limitations |
| ARULE |
ASSOCRULES |
New routine with new parameters. Migration required. |
| PREDICT_ARULE |
PREDICT_ASSOCRULES |
New routine with new parameters. Migration required. |
| PRINT_ARULE |
PRINT_MODEL |
New routine with new parameters. Migration required. |
| VERIFY_ARULE |
No alternative is available. |
Not applicable. |
Classification
Table 2. Functions for classification
| Netezza function |
function |
Changes and limitations |
| CROSS_VALIDATION |
No alternative is available. |
Not applicable. |
| DECTREE |
DECTREE |
None. |
| GROW_DECTREE |
GROW_DECTREE |
None. |
| KNN |
KNN |
New sampling: 10000 by default instead of unlimited sampling. Additional parameters:
maxsize and randseed.
|
| NAIVEBAYES |
NAIVEBAYES |
None. |
| PERCENTAGE_SPLIT |
No alternative is available. |
Use classification algorithms and quality measures instead. |
| PMML_DECTREE |
PMML_MODEL |
None. |
| PMML_NAIVEBAYES |
No alternative is available. |
Not applicable. |
| PREDICT_DECTREE |
PREDICT_DECTREE |
None. |
| PREDICT_KNN |
PREDICT_KNN |
None. |
| PREDICT_NAIVEBAYES |
PREDICT_NAIVEBAYES |
None. |
| PRINT_DECTREE |
PRINT_MODEL |
Use PRINT_MODEL instead. |
| PRUNE_DECTREE |
PRUNE_DECTREE |
None. |
| TRAIN_TEST |
No alternative is available. |
Use classification algorithms and quality measures instead. |
Clustering
Table 3. Functions for clustering
| Netezza function |
function |
Changes and limitations |
| DIVCLUSTER |
No alternative is available. |
Not applicable. |
| KMEANS |
KMEANS |
The mahalanobis parameter values is not available. |
| PREDICT_DIVCLUSTER |
No alternative is available. |
Not applicable. |
| PREDICT_KMEANS |
PREDICT_KMEANS |
Not all parameter values available. |
| PREDICT_TWOSTEP |
No alternative is available. |
This stored procedure is implemented using Apache Spark, and can be used only on a system for which Spark
capability is enabled. |
| PRINT_KMEANS |
PRINT_MODEL |
Use PRINT_MODEL and the respective parameters for KMEANS instead. |
| PRINT_TWOSTEP |
PRINT_MODEL |
New routine with new parameters. Migration required. |
| SET_CLUSTERNAME |
No alternative is available. |
Not applicable. |
| TWOSTEP |
No alternative is available. |
None. |
Column properties
Table 4. Functions for column properties
| Netezza function |
function |
Changes and limitations |
| COLUMN_PROPERTIES |
COLUMN_PROPERTIES |
None. |
| GET_COLUMN_LIST |
GET_COLUMN_LIST |
None. |
| SET_COLUMN_PROPERTIES |
SET_COLUMN_PROPERTIES |
None. |
Diagnostic measures
Table 6. Functions for diagnostic measures
| Netezza function |
function |
Changes and limitations |
| ACC |
ACC |
None. |
| CERROR |
CERROR |
None. |
| CMATRIX_ACC |
CMATRIX_ACC |
None. |
| CMATRIX_STATS |
CMATRIX_STATS |
None. |
| CMATRIX_WACC |
CMATRIX_WACC |
None. |
| CONFUSION_MATRIX |
CONFUSION_MATRIX |
None. |
| FMEASURE |
FMEASURE |
None. |
| FPR |
FPR |
None. |
| MAE |
MAE |
None. |
| MSE |
MSE |
None. |
| PPV |
PPV |
None. |
| RAE |
RAE |
None. |
| RSE |
RSE |
None. |
| TPR |
TPR |
None. |
| WACC |
WACC |
None. |
Discretization
Table 7. Functions for discretization and moments
| Netezza function |
function |
Changes and limitations |
| No Netezza function is available. |
AGGDISC |
None. |
| APPLY_DISC |
APPLY_DISC |
None. |
| EFDISC |
EFDISC |
None. |
| EMDISC |
EMDISC |
None. |
| EWDISC |
EWDISC |
None. |
| EWDISC_NICE |
EWDISC_NICE |
None. |
Model management
Table 8. Functions for model management
| Netezza function |
function |
Changes and limitations |
| ALTER_MODEL |
ALTER_MODEL |
None. |
| CLEANUP |
CLEANUP |
None. |
| COPY_MODEL |
COPY_MODEL |
None. |
| DROP_ALL_MODELS |
DROP_ALL_MODELS |
None. |
| DROP_MODEL |
DROP_MODEL |
None. |
| EXPORT_MODEL |
EXPORT_MODEL |
None. |
| EXPORT_PMML |
EXPORT_PMML |
None. |
| GRANT_MODEL |
GRANT_MODEL |
None. |
| IMPORT_MODEL |
IMPORT_MODEL |
None. |
| INITIALIZE |
INITIALIZE |
Only needed on a system. |
| IS_INITIALIZED |
IS_INITIALIZED |
Only needed on a system. |
| LIST_COLPROPS |
LIST_COLPROPS |
None. |
| LIST_COMPONENTS |
LIST_COMPONENTS |
None. |
| LIST_MODELS |
LIST_MODELS |
None. |
| LIST_PARAMS |
LIST_PARAMS |
None. |
| LIST_PRIVILEGES |
LIST_PRIVILEGES |
None. |
| METADATA_ANALYZE |
No alternative is available. |
Not applicable. |
| MIGRATE_MODEL |
No alternative is available. |
Not required on Db2® systems. |
| MODEL_EXISTS |
MODEL_EXISTS |
None. |
| PMML_MODEL |
PMML_MODEL |
None. |
| PRINT_MODEL |
PRINT_MODEL |
None. |
| REGISTER_MODEL |
No alternative is available. |
Not required on Db2 systems. |
| REVOKE_MODEL |
REVOKE_MODEL |
None. |
Probability distributions
Table 9. Functions for probability distributions
| Netezza function |
function |
Changes and limitations |
| CUMULATIVE |
No alternative is available. |
Not applicable. |
| DBERN |
DBERN |
None. |
| DBETA |
DBETA |
None. |
| DBINOM |
DBINOM |
None. |
| DCAUCHY |
DCAUCHY |
None. |
| DCHISQ |
DCHISQ |
None. |
| DENSITY |
DENSITY |
None. |
| DEXP |
DEXP |
None. |
| DF |
DF |
None. |
| DFISK |
DFISK |
None. |
| DGAMMA |
DGAMMA |
None. |
| DGEOM |
DGEOM |
None. |
| DHYPER |
DHYPER |
None. |
| DLNORM |
DLNORM |
None. |
| DLOGIS |
DLOGIS |
None. |
| DMWW |
DMWW |
None. |
| DNBINOM |
DNBINOM |
None. |
| DNORM |
DNORM |
None. |
| DNORM3P |
DNORM3P |
None. |
| DPOIS |
DPOIS |
None. |
| DT |
DT |
None. |
| DUNIF |
DUNIF |
None. |
| DWALD |
DWALD |
None. |
| DWEIBULL |
DWEIBULL |
None. |
| DWILCOX |
DWILCOX |
None. |
| PBERN |
PBERN |
None. |
| PBERN_H |
PBERN_H |
None. |
| PBETA |
PBETA |
None. |
| PBETA_H |
PBETA_H |
None. |
| PBINOM |
PBINOM |
None. |
| PBINOM_H |
PBINOM_H |
None. |
| PCAUCHY |
PCAUCHY |
None. |
| PCAUCHY_H |
PCAUCHY_H |
None. |
| PCHISQ |
PCHISQ |
None. |
| PCHISQ_H |
PCHISQ_H |
None. |
| PCHISQ_S |
PCHISQ_S |
None. |
| PEXP |
PEXP |
None. |
| PEXP_H |
PEXP_H |
None. |
| PF |
PF |
None. |
| PF_H |
PF_H |
None. |
| PFISK |
PFISK |
None. |
| PFISK_H |
PFISK_H |
None. |
| PGAMMA |
PGAMMA |
None. |
| PGAMMA_H |
PGAMMA_H |
None. |
| PGEOM |
PGEOM |
None. |
| PGEOM_H |
PGEOM_H |
None. |
| PHYPER |
PHYPER |
None. |
| PHYPER_H |
PHYPER_H |
None. |
| PLNORM |
PLNORM |
None. |
| PLNORM_H |
PLNORM_H |
None. |
| PLOGIS |
PLOGIS |
None. |
| PLOGIS_H |
PLOGIS_H |
None. |
| PMWW |
PMWW |
None. |
| PMWW_H |
PMWW_H |
None. |
| PNBINOM |
PNBINOM |
None. |
| PNBINOM_H |
PNBINOM_H |
None. |
| PNORM |
PNORM |
None. |
| PNORM3P |
PNORM3P |
None. |
| PNORM_H |
PNORM_H |
None. |
| PPOINT |
PPOINT |
None. |
| PPOIS |
PPOIS |
None. |
| PPOIS_H |
PPOIS_H |
None. |
| PT |
PT |
None. |
| PT_H |
PT_H |
None. |
| PUNIF |
PUNIF |
None. |
| PUNIF_H |
PUNIF_H |
None. |
| PWALD |
PWALD |
None. |
| PWALD_H |
PWALD_H |
None. |
| PWEIBULL |
PWEIBULL |
None. |
| PWEIBULL_H |
PWEIBULL_H |
None. |
| PWILCOX |
PWILCOX |
None. |
| PWILCOX_H |
PWILCOX_H |
None. |
| QBERN |
QBERN |
None. |
| QBERN_H |
QBERN_H |
None. |
| QBETA |
QBETA |
None. |
| QBETA_H |
QBETA_H |
None. |
| QBINOM |
QBINOM |
None. |
| QBINOM_H |
QBINOM_H |
None. |
| QCAUCHY |
QCAUCHY |
None. |
| QCAUCHY_H |
QCAUCHY_H |
None. |
| QCHISQ |
QCHISQ |
None. |
| QCHISQ_H |
QCHISQ_H |
None. |
| QEXP |
QEXP |
None. |
| QEXP_H |
QEXP_H |
None. |
| QF |
QF |
None. |
| QF_H |
QF_H |
None. |
| QFISK |
QFISK |
None. |
| QFISK_H |
QFISK_H |
None. |
| QGAMMA |
QGAMMA |
None. |
| QGAMMA_H |
QGAMMA_H |
None. |
| QGEOM |
QGEOM |
None. |
| QGEOM_H |
QGEOM_H |
None. |
| QHYPER |
QHYPER |
None. |
| QHYPER_H |
QHYPER_H |
None. |
| QLNORM |
QLNORM |
None. |
| QLNORM_H |
QLNORM_H |
None. |
| QLOGIS |
QLOGIS |
None. |
| QLOGIS_H |
QLOGIS_H |
None. |
| QMWW |
QMWW |
None. |
| QMWW_H |
QMWW_H |
None. |
| QNBINOM |
QNBINOM |
None. |
| QNBINOM_H |
QNBINOM_H |
None. |
| QNORM |
QNORM |
None. |
| QNORM3P |
QNORM3P |
None. |
| QNORM_H |
QNORM_H |
None. |
| QPOIS |
QPOIS |
None. |
| QPOIS_H |
QPOIS_H |
None. |
| QT |
QT |
None. |
| QT_H |
QT_H |
None. |
| QUNIF |
QUNIF |
None. |
| QUNIF_H |
QUNIF_H |
None. |
| QWALD |
QWALD |
None. |
| QWALD_H |
QWALD_H |
None. |
| QWEIBULL |
QWEIBULL |
None. |
| QWEIBULL_H |
QWEIBULL_H |
None. |
| QWILCOX |
QWILCOX |
None. |
| QWILCOX_H |
QWILCOX_H |
None. |
Quantiles and outliers
Table 10. Functions for quantiles and outliers
| Netezza function |
function |
Changes and limitations |
| IQR |
No alternative is available. |
Not applicable. |
| MEDIAN |
No alternative is available. |
Not applicable. |
| MEDIAN_DISC |
No alternative is available. |
Not applicable. |
| OUTLIERS |
No alternative is available. |
Not applicable. |
| QUANTILE |
No alternative is available. |
Not applicable. |
| QUANTILE_DISC |
No alternative is available. |
Not applicable. |
| QUARTILE |
No alternative is available. |
Not applicable. |
| QUARTILE_DISC |
No alternative is available. |
Not applicable. |
Regression
Table 11. Functions for regression
| Netezza function |
function |
Changes and limitations |
| BTBNET_GROW |
No alternative is available. |
Not applicable. |
| GLM |
No alternative is available. |
None. |
| GROW_REGTREE |
GROW_REGTREE |
None. |
| LINEAR_REGRESSION |
LINEAR_REGRESSION |
Not available on Linux
on IBM z Systems. |
| MTBNET_DIFF |
No alternative is available. |
Not applicable. |
| MTBNET_GROW |
No alternative is available. |
Not applicable. |
| PREDICT_GLM |
No alternative is available. |
None. |
| PREDICT_LINEAR_REGRESSION |
PREDICT_LINEAR_REGRESSION |
Not available on Linux
on IBM z Systems. |
| PREDICT_REGTREE |
PREDICT_REGTREE |
None. |
| PRINT_GLM |
No alternative is available. |
Not applicable. |
| PRINT_REGTREE |
PRINT_MODEL |
Use PRINT_MODEL instead. |
| PRUNE_REGTREE |
PRUNE_REGTREE |
None. |
| REGTREE |
REGTREE |
None. |
| TANET_APPLY |
No alternative is available. |
Not applicable. |
| TANET_CLASSAPPLY |
No alternative is available. |
Not applicable. |
| TANET_GROW |
No alternative is available. |
Not applicable. |
| TBNET1G |
No alternative is available. |
Not applicable. |
| TBNET1G2P |
No alternative is available. |
Not applicable. |
| TBNET2G |
No alternative is available. |
Not applicable. |
| TBNET_APPLY |
No alternative is available. |
Not applicable. |
| TBNET_GROW |
No alternative is available. |
Not applicable. |
Sampling
Table 12. Functions for sampling
| Netezza function |
function |
Changes and limitations |
| RANDOM_SAMPLE |
RANDOM_SAMPLE |
None. |
Sequential patterns
Table 13. Functions for sequential patterns
| Netezza function |
function |
Changes and limitations |
| PREDICT_SEQRULES |
PREDICT_SEQRULES |
None. |
| PRINT_SEQRULES |
PRINT_MODEL |
Use PRINT_MODEL instead. |
| PRUNE_SEQRULES |
PRUNE_SEQRULES |
None. |
| SEQRULES |
SEQRULES |
None. |
Statistics
Table 14. Functions for statistics
| Netezza function |
function |
Changes and limitations |
| ANOVA_CRD_TEST |
ANOVA_CRD_TEST |
None. |
| ANOVA_RBD_TEST |
ANOVA_RBD_TEST |
None. |
| BITABLE |
No alternative is available. |
Not applicable. |
| CHISQ_TEST |
CHISQ_TEST |
None. |
| CHISQ_TEST_AGG |
CHISQ_TEST_AGG |
None. |
| CHISQ_TEST_S_AGG |
CHISQ_TEST_S_AGG |
None. |
| COL2TRCV_MANOVA_ONE_WAY_TEST |
No alternative is available. |
Not applicable. |
| COL2TRCV_MANOVA_TWO_WAY_TEST |
No alternative is available. |
Not applicable. |
| DROP_SUMMARY1000 |
DROP_SUMMARY1000 |
None. |
| HIST |
No alternative is available. |
Not applicable. |
| JOINT_ENTROPY |
JOINT_ENTROPY |
None. |
| KURTOSIS_AGG |
KURTOSIS_AGG |
None. |
| LDF_MANOVA_ONE_WAY_TEST |
No alternative is available. |
Not applicable. |
| LDF_MANOVA_TWO_WAY_TEST |
No alternative is available. |
Not applicable. |
| MANOVA_ONE_WAY_TEST |
No alternative is available. |
Not applicable. |
| MANOVA_TWO_WAY_TEST |
No alternative is available. |
Not applicable. |
| MOMENTS |
MOMENTS |
None. |
| MUTUALINFO |
MUTUALINFO |
None. |
| MUTUALINFO_AGG |
MUTUALINFO_AGG |
None. |
| MWW_TEST |
MWW_TEST |
None. |
| No Netezza function is available. |
NUMERIC_SUMMARY |
None. |
| PRINT_MANOVA_ONE_WAY_TEST |
No alternative is available. |
Not applicable. |
| PRINT_MANOVA_TWO_WAY_TEST |
No alternative is available. |
Not applicable. |
| SKEWNESS_AGG |
SKEWNESS_AGG |
None. |
| SPEARMAN_CORR |
SPEARMAN_CORR |
None. |
| SPEARMAN_CORR_S |
No alternative is available. |
Not applicable. |
| SUMMARY1000 |
SUMMARY1000 |
The talk parameter is deprecated and has no action. |
| SUMMARY1000CHAR |
SUMMARY1000CHAR |
The talk parameter is deprecated and has no action. |
| SUMMARY1000DATE |
SUMMARY1000DATE |
The talk parameter is deprecated and has no action. |
| SUMMARY1000INTERVAL |
No alternative is available. |
Not applicable. |
| SUMMARY1000NUM |
SUMMARY1000NUM |
The talk parameter is deprecated and has no action. |
| SUMMARY1000TIME |
SUMMARY1000TIME |
The talk parameter is deprecated and has no action. |
| SUMMARY1000TIMESTAMP |
SUMMARY1000TIMESTAMP |
The talk parameter is deprecated and has no action. |
| T_LS_TEST |
T_LS_TEST |
The output table has a different format. |
| T_LS_TEST_S_AGG |
T_LS_TEST_S_AGG |
None. |
| T_ME_TEST |
T_ME_TEST |
The output table has a different format. |
| T_ME_TEST_S_AGG |
T_ME_TEST_S_AGG |
None. |
| T_PMD_TEST |
T_PMD_TEST |
The output table has a different format. |
| T_PMD_TEST_S_AGG |
No alternative is available. |
Not applicable. |
| T_TEST_AGG |
T_TEST_AGG |
The output table has a different format. |
| T_TEST_S_AGG |
T_TEST_S_AGG |
None. |
| No Netezza function is available. |
SPLIT_TEST_S |
None. |
| T_UMD_TEST |
T_UMD_TEST |
The output table has a different format. |
| UNITABLE |
No alternative is available. |
Not applicable. |
| WILCOXON_TEST |
WILCOXON_TEST |
None. |
Timeseries
Table 15. Functions for timeseries
| Netezza function |
function |
Changes and limitations |
| PRINT_TIMESERIES |
No alternative is available. |
Not applicable. |
| TIMESERIES |
No alternative is available. |
Not applicable. |
Utilities
Table 16. Functions for utilities
| Netezza function |
function |
Changes and limitations |
| msghelp |
No alternative is available. |
Not applicable. |
| _sp_utl_dropAllAggregates |
No alternative is available. |
Not applicable. |
| _sp_utl_dropAllFunctions |
No alternative is available. |
Not applicable. |
| _sp_utl_dropAllLike |
No alternative is available. |
Not applicable. |
| _sp_utl_dropAllProcedures |
No alternative is available. |
Not applicable. |
| _sp_utl_dropAllUDX |
No alternative is available. |
Not applicable. |
| _sp_utl_justExecute |
No alternative is available. |
Not applicable. |
| DROP_TABLE |
No alternative is available. |
Not applicable. |
| _sp_utl_aggregateExists |
No alternative is available. |
Not applicable. |
| _sp_utl_columnContainsNulls |
No alternative is available. |
Not applicable. |
| _sp_utl_columnExists |
No alternative is available. |
Not applicable. |
| _sp_utl_columnIsId |
No alternative is available. |
Not applicable. |
| _sp_utl_columnIsNumeric |
No alternative is available. |
Not applicable. |
| _sp_utl_columnListExists |
No alternative is available. |
Not applicable. |
| _sp_utl_columnsEqualTypes |
No alternative is available. |
Not applicable. |
| _sp_utl_functionExists |
No alternative is available. |
Not applicable. |
| _sp_utl_isTempTable |
No alternative is available. |
Not applicable. |
| _sp_utl_procedureExists |
No alternative is available. |
Not applicable. |
| _sp_utl_relationExists |
No alternative is available. |
Not applicable. |
| _sp_utl_sequenceExists |
No alternative is available. |
Not applicable. |
| _sp_utl_tableExists |
No alternative is available. |
Not applicable. |
| _sp_utl_viewExists |
No alternative is available. |
Not applicable. |
| ISDATE_TINY |
No alternative is available. |
Not applicable. |
| _sp_utl_getColumnType |
No alternative is available. |
Not applicable. |
| _sp_utl_getTableSize |
No alternative is available. |
Not applicable. |
| drand64 |
No alternative is available. |
Not applicable. |