|
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
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
