I have used the "select * into tablename" statment in MS SQL.
Now, since I got DB2 for iSeries, I need to be able to run a query that creates a new table on the fly.

How can I do that?

I appreciate any help (sql code or URL LINK with help)

Thank you.