rennet17
Last Activity: Apr 24 '12, 06:29 PM
Joined: Apr 24 '12
Location:
-
No i did not put < > i just replaced the real table name with that. -
I working on AQT tool on DB2Leave a comment:
-
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_exp r>". SQLSTATE=42601Leave a comment:
-
insert into first (select * from <old_table>)Leave a comment:
-
is an undefined name. SQLSTATE=42704
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.FI RST" is an undefined name. SQLSTATE=42704
...
No activity results to display
Leave a comment: