RE: Multi-row insert in SQL

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Can't multi-row INSERTs also be effected by INSERTing values via a subselect? 
By having the values loaded into an intermediate table, it's similar to loading 
from an array though maybe not as convenient in a program when the values are 
already available.

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>   5. RE: Multi-row insert in SQL (Chevalier, Rick)
>
>You can do it if the SQL is embedded in a program.  I know you code mostly C
>but in RPG you would use a multiple occurrence data structure.
>
>-----Original Message-----
>From: Vern Hamberg
>
>Anyone know if or when iSeries SQL will have a multi-row INSERT?
>
>INSERT INTO tab_comp VALUES     (item1, price1, qty1),
>                                 (item2, price2, qty2),
>                                 (item3, price3, qty3)
>
>instead of
>
>INSERT INTO tab_comp VALUES (item1, price1, qty1)
>INSERT INTO tab_comp VALUES (item2, price2, qty2)
>INSERT INTO tab_comp VALUES (item3, price3, qty3)

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455