View previous topic :: View next topic
|
Author |
Message |
abiyn
New User
Joined: 25 Mar 2008 Posts: 12 Location: Chennai
|
|
|
|
Could you pls tell me what is wrong in this statement
CREATE TABEL TESTID AS (SELECT * FROM EMP_DETAIL)
I am getting the below error message
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD AS. TOKEN FOR WAS
EXPECTED
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
Thanks in Advance
Regards
Abi |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi abiyn !
Are you shure, you want to create a Table ???
CREATE VIEW viewname columnname,.. AS Subselect
Regards, UmeySan |
|
Back to top |
|
|
abiyn
New User
Joined: 25 Mar 2008 Posts: 12 Location: Chennai
|
|
|
|
Yes UmeySan
I want to create Materialized query table.
The syntax for that is
Create table tbname as (select column_name from tablename1).
But this is not working in Mainframe-DB2, But I have created the table using the same in Linux-Db2 environment. |
|
Back to top |
|
|
|