MQT staging table getting SQL code

[nirjaparayane]

I am trying to create a staging table for a summary-mqt-table -
create table staging_mqt for mqt_table propagate immediate

I am getting sql code -199 sqlstate 42601 - illegal use of keyword for.


i have created the mqt with refresh defered, data initially defered option.

we are using db210. i am able to create mqt easily but facing issues in creating incremental mqt.

[Anas Mosaad]

It's weird that DB2 v 10.1 saying "NOTE: This error is only applicable to releases of DB2 prior toVersion 2"

Would you please share the code causing the issue to be able to support you?

[nirjaparayane]

Hi,
i cannot share the exact code code is in followin format -
create mqt_table
(select sum(field1+fiel d2...+field10) from table where fld2 = :val group by colx, coly, colz...) data initially defered refresh defered

--------------------------------
--------------------------------

this works fine and table is created..

create table mqt_staging for mqt_table propoate immediate

Here table is a partitioned table I tried same with non-partitioned table still getting same error