Thread: DB2 - SELECT - INTO Statement
View Single Post

  #2 (permalink)  
Old 02-17-2006, 07:36 AM
sanereddy sanereddy is offline
Senior Member
  
Join Date: Nov 2004
Posts: 175
sanereddy is an unknown quantity at this point
Hello,

DB2 Support select into.... here is an example...

INSERT INTO table1
SELECT field1, field2 FROM table2
WHERE field3='test';


Hope this helps...

Thanks,
Reply With Quote