User Profile

Collapse

Profile Sidebar

Collapse
nirjaparayane
nirjaparayane
Last Activity: May 21 '14, 07:06 AM
Joined: May 16 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nirjaparayane
    replied to MQT staging table getting SQL code
    in DB2
    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...
    See more | Go to post

      Leave a comment:

    • nirjaparayane
      started a topic MQT staging table getting SQL code
      in DB2

      MQT staging table getting SQL code

      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.
      See more | Go to post
      No activity results to display
      Show More
      Working...