| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Regarding SELECT INSERT in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| Deepak_reddy |
 Posted: Mon Mar 12, 2007 9:44 pm Post subject: Regarding SELECT INSERT in ESQL |
 |
|
Novice
Joined: 04 Sep 2006
Posts: 10
|
Hi all,
Is there are any mechanism in ESQL to insert the result of a Select Operation into a table without creating extra variables. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Mar 12, 2007 10:28 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Deepak_reddy,
I doubt it...or atleast you will have to do something like this
INSERT INTO(1,2,3) VALUES(SELECT 1 FROM, SELECT 2 FROM, SELECT 3 FROM);
Even this I doubt will work in ESQL, but you could try....but then rather than doing this, you could simply create the elements 
Maybe you should look at stored procedures for this.
Regards. |
|
| Back to top |
|
|
| Deepak_reddy |
| Posted: Tue Mar 13, 2007 8:06 pm Post subject: |
|
|
Novice
Joined: 04 Sep 2006
Posts: 10
|
Thanks Elvis,
I would try your suggestion on stored procedures .... |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
