Re: Multiple Row Insert in SQL?

[rob@xxxxxxxxx]

What business ap would do it this way though?  Let's see, someone is 
entering orders.  I'm not supposed to write out orders until they've:
- entered a certain number of orders
- exit the program
- or I time out the program and exit it for them?
Sure would be heck if someone cancelled the job because of some record 
lock, maintenance, etc.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/04/2003 08:25 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Multiple Row Insert in SQL?






Unfortunately that syntax is not available at V5R2 in the iSeries version 
of DB2 - it is in all the others. Maybe we can hope. Because a single 
statement with multiple sets of values runs better than multiple 
statements, each with 1 set of values. This is an optimization 
recommendation in the other flavors of DB2.

So, for the moment anyway, out of luck.

Vern

At 05:24 PM 11/3/2003 -0600, you wrote:
>I thought the format was something like
>
>INSERT INTO mytable (field1, field2, field3) values 
('blah1','blah2','blah3'),
>('blah2a','blah2b','blah2c'), ('blahagain','andagain','andagain');
>
>HTH,
>Loyd
>
>On Mon, 03 Nov 2003 18:00:16 -0500, "Michael Naughton"
><mnaughton@xxxxxxxxxxxx> wrote:
>
> >Is there any way to insert multiple rows into a table without  using a
> >select clause? I'd like to build a SQL statement in a program that just
> >contains discrete values (no references to anything outside of the
> >statement except the table being inserted into). It works fine with 
just
> >one row, but I can't get VALUES to work with more than one.
> >
> >Am I just out of luck?  Thanks!
> >
> >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.