ANL2027I NO TABLE STATS FOR QUERY: queryno BLOCK: qblockno COMMON TABLE EXPRESSION OR RECURSIVE COMMON TABLE EXPRESSION WAS USED.

Explanation

SQL of the form WITH table-expression AS table name, SELECT… was used to define a table and then access it in subsequent SQL. This type of SQL is referred to as a common table expression, and it allows you to define an instant table or view of the data, and then use it, within a single SQL statement.

User response

None This message is informational. There are no stats in the catalog for an instantly defined table.