0 - 3 of 3 tags for #insert

Hello All. 
We have two tables as below. Both the tables have 1 column COLLECT_DATE_TIME Timestamp(1).
1. DB_DEV.ABCD
2. DB_TEST.ABCD
 

Hello All,

 

I am doing a simple Select Insert through a Bteq job like below. The count is huge around 500 millions.

I'm trying to INSERT INTO a table or CREATE TABLE AS from a SQL statement using the WITH form of a derived table.  Is this possible?