473,385 Members | 1,740 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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.
May 16 '14 #1
2 1589
Anas Mosaad
185 128KB
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?
May 19 '14 #2
Hi,
i cannot share the exact code code is in followin format -
create mqt_table
(select sum(field1+field2...+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
May 20 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Zri Man | last post by:
I have searched far and wide (not wide enough some might chip in) but cannot find the syntax for creating a staging table for an MQT. IBM manuals talk long and longer in serveral sections of this...
13
by: Peter | last post by:
Can anyone tell me how to change the data type of a field in a table created with a make table query? The field is a binary and must be changed to text. alternately does anyone know how to specify...
2
by: ms | last post by:
Access 2000: I am trying to delete duplicate records imported to a staging table leaving one of the duplicates to be imported into the live table. A unique record is based on a composite key of 3...
0
by: ellenricca | last post by:
I have a temp table that is created when data is imported from a text file. The data is of a certain student population. I also have 10 different Access tables that are named according to the 10...
4
by: Regnab | last post by:
As any good code pirate would, I have duly copied the code suggested in this forum from 1998(VBA method to determine number of columns in a table??) but I keep getting an error "Object Required"......
6
by: Klemens | last post by:
I want to create an MQT, intialize it manually and then use staging table to refresh it with new data, but i don' t see a way for not doing full refresh after creating the staging table. I tried...
2
by: travhale | last post by:
in a new project using .net 2005, c#. getting err message "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." source RDBMS is oracle 8i. I add a new...
3
by: Galka | last post by:
Hello Why do you think a create table query doesn't create table from the following code? Set myQuery = myDB.QueryDefs("qryCON absent adults previous day log") myQuery.Execute If I execute...
2
by: Richard Drysdall | last post by:
Hi. In C/C++, I'm used to using a table-driven approach for some problems to avoid large case statements. For example (off the top of my head, may contain syntax errors and error checking...
9
by: dli07 | last post by:
Hello, I'm trying to convert a piece of code that creates a dynamic vertical resizing bar in a table from internet explorer to firefox. It's based on a post from...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.