Re: Multiple Row Insert in SQL?

Will a multiple row insert from a sub-select work. Something like this.

 insert into test (itnbr,house) select itnbr,house from amfliba/itembl
  where itnbr = '01136'

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


|---------+------------------------------->
|         |           "Michael Naughton"  |
|         |           <mnaughton@juddwire.|
|         |           com>                |
|         |           Sent by:            |
|         |           midrange-l-bounces@m|
|         |           idrange.com         |
|         |                               |
|         |                               |
|         |           11/04/2003 02:27 PM |
|         |           Please respond to   |
|         |           Midrange Systems    |
|         |           Technical Discussion|
|         |                               |
|---------+------------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       To:       Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>                                              |
  |       cc:                                                                   
                                                 |
  |       Subject:  Re: Multiple Row Insert in SQL?                             
                                                 |
  
>------------------------------------------------------------------------------------------------------------------------------|




I'm not 100% clear on the details, but in this case we have an application
in Domino that offers our business partners the opportunity to upload
information from their systems (orders, sales forecasts, RFQs, whatever).
Once their data is in Domino, we want to move it over to our AS/400, and
our developer has chosen SQL inserts for the task.

There may well be a better way, but he's been doing a fair number of
Domino to AS/400 integration projects here, and I think he's pretty
familiar with the possibilities. Doing row-at-a-time inserts works, but
it's just kind of slow, so I told him I'd see if I could find a way to
speed it up, and I thought multiple row inserts might work.

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
>>What business ap would do it this way though?


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.