× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks for clearing that up, Vern! At least now I know why none of the
examples and documentation I found seemed to work . . . .

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
>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');


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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.