create table table1 as select .. from sysibm.sysdummy1

Question

In DERBY,

I have a table which name is TEST1. I can run this code perfectly.

CREATE TABLE Table1 AS (SELECT * FROM TEST1) with no data

But I can't run this code and derby.

CREATE TABLE Table1 AS (SELECT ..... FROM sysibm.sysdummy1) with no data

editor throws this error :

ERROR: The CREATE TABLE statement does not include a column list.

ps: "SELECT ..... FROM sysibm.sysdummy1" works with no problem.

How can I create a table with using "select 'columns' from sysibm.sysdummy1" ?

Please show us your *real* SQL, because obviously, you are **not** using `SELECT ..... FROM sysibm.sysdummy1` — , Nov 28 '13 at 09:37

score 1 · Accepted Answer · answered Nov 29 '13 at 07:57

1

in my first code

CREATE TABLE Table1 AS (SELECT ..... x, y, z , 0 FROM sysibm.sysdummy1) with no data

I deleted comma and 0 in query and fixed it! Like that

CREATE TABLE Table1 AS (SELECT ..... x, y, z FROM sysibm.sysdummy1) with no data

answered Nov 29 '13 at 07:57

neverwinter

810
2
15
42

score 0 · Answer 2 · answered Nov 28 '13 at 16:00

0

I think the problem may be that the "dummy" table has no columns, and since you specified no columns in your CREATE TABLE statement, Derby is trying to use the columns from the dummy table, and failing to find any, and saying "does not include a column list".

Why not specify the columns you desire in your result table?

For (a little bit) more information about the dummy table, see: http://apache-database.10148.n7.nabble.com/SYSIBM-schema-td74269.html

answered Nov 28 '13 at 16:00

Bryan Pendleton

16,128
3
32
56

I don't specify the columns which I desire in my result table because table has more than 200 columns. – neverwinter Nov 29 '13 at 07:54

create table table1 as select .. from sysibm.sysdummy1

2 Answers2

Linked