I tried to create summary table with the following Syntax, which resulted
in following error msg.

Also i tried to create summary table using DATA INITIALLY DEFERRED REFRESH
DEFERRED.
But still same error is thrown out.

db2 => CREATE TABLE summary2 AS \
db2 (cont.) => ( \
db2 (cont.) => select count(vemail) from msg,reportng where
msg.ticket=reportng.ticket \
db2 (cont.) => ) \
db2 (cont.) => DATA INITIALLY DEFERRED REFRESH deferred \
db2 (cont.) => ENABLE QUERY OPTIMIZATION \
db2 (cont.) => MAINTAINED BY SYSTEM

DB21034E The command was processed as an SQL statement because it was not
a
valid Command Line Processor command. During SQL processing it returned:
SQL20058N The fullselect specified for the materialized query table
"DEVAIX1.SUMMARY2" is not valid. SQLSTATE=428EC


Pls. help me to close this ASAP.

Thanks In Advance
saiprasad

DB2 & UDB email list listserv db2-l LazyDBA home page