Exforsys

Online Training

DB2 - SELECT - INTO Statement

This is a discussion on DB2 - SELECT - INTO Statement within the DB2 forums, part of the Database category; Hello Members I need correct syntax for writing SELECT - INTO statement with ORDER BY clause. Can anyone of you please ...


Go Back   Exforsys > Database > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-17-2006, 02:29 AM
Junior Member
 
Join Date: Jan 2006
Posts: 12
James Allen is on a distinguished road
DB2 - SELECT - INTO Statement

Hello Members

I need correct syntax for writing SELECT - INTO statement with ORDER BY clause. Can anyone of you please help me. Does DB2 support such SELECT Statement.

Awaiting your early response.

Regards
Allen
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-17-2006, 07:36 AM
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,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-17-2006, 12:19 PM
Junior Member
 
Join Date: Jan 2006
Posts: 12
James Allen is on a distinguished road
Hello Senereddy

Thanks for your quick response,
I would like to confirm again the SELECT Statement with an Order By Clause.
After you send me the syntax, I will try to test it on my system.
I am asking very simple syntax, Hope you wont mind.

Thanks again.
Cheers
Allen
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:40 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.