RE: Multi-row insert in SQL

midrange-l-request@xxxxxxxxxxxx wrote:

>   5. RE: Multi-row insert in SQL (Vern Hamberg)
>
>Right, Tom. But, of course, you need to have populated the intermediate 
>table somehow.  ;-)
>
>It seems that the mechanism for adding multiple records exists in the 
>engine, since both the MODS RPG process and the subselect process are handled.
>
>Right now, the place I'd find the unsupported syntax to be helpful is in 
>interactive SQL, when I'm trying to populate a file for testing.

Sorry, Vern, I should've seen ISQL coming. For me, maybe the choice would be to 
use EDTF to type into a CSV file and then CPYFRMIMPF to get them into a 
database format. I know, that might as well put them into your final table; but 
maybe you need to append sets of rows to your table or massage them otherwise 
before INSERT. And THEN the subselect...?

Tom Liotta

-- 
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