Create table from another table in DB2 database

We can create a table from another table definition but without data in DB2. We need write a another sql to insert the data into newly created table.

Let's see how to do this --



Create Duplicate table with NO DATA
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------


Insert data into duplicated table from original table
-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------




Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098