Re: Multiple Row Insert in SQL?

["Michael Naughton" <mnaughton@xxxxxxxxxxxx>]

Unless I'm missing something, that works fine only as long as the database
that is being sub-selected from lives on the same platform as the
datatabase being inserted into.

Our problem is that we've got the data on one platform (Domino), and we're
constructing a SQL statement and then using ODBC to send it to the other
platform (our AS/400).  So I don't see how we can refer to other tables,
field names, etc. that exist in Domino; the only option we have is to
construct the statement using the values they represent. Or am I missing
something?

Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:
>Yup
>
>At 02:36 PM 11/4/2003 -0500, you wrote:
>
>>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


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