User Profile
Collapse
-
No i did not put < > i just replaced the real table name with that. -
-
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:
-
-
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
Show More
Leave a comment: