Analyze Table Expression

Description

Returns the result of executing a specific data mining model by using an in-database analytics provider, a named model implementation, and input data.

Click here to navigate to the IBM DB2 docs page for this syntax.

Analyze Table Expressions are not supported in Snowflake. The output query can be malformed

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

SELECT
   *
FROM v1 ANALYZE_TABLE(
   IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;')
ORDER BY 1;

Snowflake

Code 1

SELECT
   *
FROM
-- ** MSC-ERROR - MSCEWI1021 - ANALYZE TABLE FACTOR NOT SUPPORTED **
--     v1 ANALYZE_TABLE(
--   IMPLEMENTATION 'PROVIDER=SAS; ROUTINE_SOURCE_TABLE=ETLIN.SOURCE_TABLE; ROUTINE_SOURCE_NAME=SCORING_FUN3;')
ORDER BY 1;

Related EWIs

1. MSCEWI1021: NODE NOT SUPPORTED