is an undefined name. SQLSTATE=42704

[rennet17]

I am trying to create a table from an existing table and i need the existing tables data in my new table, So i submitted the following statement


insert into first (select * from <old_table>

but i am getting the following error

Error during Prepare
S0002(-204)[IBM][CLI Driver][DB2/AIX64] SQL0204N "RNOEL03.FIRST" is an undefined name. SQLSTATE=42704


can you please help

Thanks

[rennet17]

insert into first (select * from <old_table>)

[Rabbit]

The correct syntax to create a table from a SELECT query is this:

SELECT *
INTO newTable
FROM oldTable

[rennet17]

i did that
select * into st from <old_table>

but i am getting this

error Error during Prepare
42601(-104)[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "into st from <old_table>" was found following "select * ". Expected tokens may include: "<table_expr>". SQLSTATE=42601

[rennet17]

I working on AQT tool on DB2

[Rabbit]

You actually put in <>? I thought you were just doing that in place of the actual table name. Remove them, they are not correct syntax.

[rennet17]

No i did not put < > i just replaced the real table name with that.

[Rabbit]

It looks like DB2 does not support the SELECT INTO syntax to create tables. You'll have to use two SQL statements. One create statement and one insert statement.