var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 equivalent of Oracle Create table ... as select ...
Is their a direct equivalent in DB2 to create a table with a select ?
in Oracle it goes somethng like this:
create table newtable as Select * from mytable;
This was discussed recently. I don't recall all the options, but you can do it with these 2 SQL statements using begin atomic (if needed):
Create table new_table like old_table;
Insert into new_table select * from old table ... ;
Following should also work
db2 "create <NEWTABLE> as (select * from <EXISTINGTABLE) definition only "
db2 "create <NEWTABLE> as (select * from <EXISTINGTABLE) WITH NO DATA"