DB2 INSERT INTO vs SELECT INTO

In DB2 if you need to populate a table, you need to use INSERT INTO, like in this example:

INSERT INTO new_table
SELECT col1,col2 FROM source_table
WHERE col1='something';

and if you need to populate query variable, you need to use SELECT INTO, like in this example:

SELECT * INTO :var1, :var2, :var3FROM table_name
WHERE col1= 'something'; 

Source: DB2 Documentation

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • Blogplay
  • email
  • LinkedIn
  • PDF
  • Ping.fm
  • RSS
  • Slashdot
  • Twitter
This entry was posted in DB2 and tagged , , , , , , , . Bookmark the permalink.
blog comments powered by Disqus