IBM Mainframe Forum

Hi All

How we can create a table similar to the output of query?

Suppose we want to create a table TAB1
and I have a query like

Select * from Table2

Can I write a query like

CREATE TABLE TAB1 AS
SELECT *
FROM Table2

Hello nitinsharma_1212 and welcome to the forums,

Yes, you should be able to create a new table like that.

Here' s a link to CREATE for DB2 V9:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/SEARCH?Book=dsnsqk10&searchRequest=create+table&SEARCH=Search&Type=FUZZY&SHELF=&DT=20070125023435&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK

Good luck