Thanks everyone for your response.
----- Original Message -----
From: "John Lantz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:34 AM
Subject: RE: DB2EUG: Insert Into command in DB2
>
> With Federated databases in V7 on UDB, you can have a nickname set up that
> points to a mainframe table and you can do the following SQL while
> connected to the UDB database on the Windows 2000 server:
>
> INSERT INTO table_on_udb SELECT * FROM table_on_mainframe
>
> Again, there is set up stuff that you got to do to get Federated databases
> working (setting up nicknames, etc...). But I'm 99% sure that you could
> have your nickname pointing to another UDB database rather than the
> mainframe (or even Oracle) and do what you want in one SQL statement.
>
> Thanks.
>
>
>
>
> "Napolitano, Fabrizio" <[EMAIL PROTECTED]>@lists1.ba.best.com on
> 09/07/2001 09:14:48 AM
>
> Please respond to [EMAIL PROTECTED]
>
> Sent by: [EMAIL PROTECTED]
>
>
> To: [EMAIL PROTECTED]
> cc:
>
> Subject: RE: DB2EUG: Insert Into command in DB2
>
>
>
> No this won't work if your tables reside in 2 different tables.
>
> Even the Federate Database features I don't know if can be usefull for you
> at least at this version, infact with Federates DBs you can only read and
> join data that are stored in tables of different DBs but you can't update
> them in this way.
>
> The only things that comes to my mind is that maybe you can federate the
> dbs
> in the way that the table you update is local while the table you read is
> the remote one, so maybe this still worth a try.
>
> Hope this helps
>
> Fabrizio
>
> -----Original Message-----
> From: Pranay Kumar Akhouri
> To: [EMAIL PROTECTED]
> Sent: 07/09/01 13.30
> Subject: Re: DB2EUG: Insert Into command in DB2
>
> Will this work in case of two different database tables?
>
>
> John Dbms <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 09/06/2001 01:14 PM MST
> Please respond to db2eug
>
> To: [EMAIL PROTECTED]
> cc:
> bcc:
> Subject: Re: DB2EUG: Insert Into command in DB2
>
>
>
>
> You could do:
> INSERT INTO TABLE2 SELECT * FROM TABLE1
> --- LeGrand Decius <[EMAIL PROTECTED]> wrote:
> > Hello everyone,
> >
> > Is there a DB2 SQL syntax to insert data from one
> > database table to another database table.
> > I would like to avoid exporting and importing data.
> >
> > This what I have in mind.
> >
> >
> > Example:
> >
> > Database Names: (MEMDB1 and MEMDB2)
> > UserName: test
> > Schemas (tst and prod)
> >
> > connect to MEMDB1 user test;
> >
> > connect to MEMDB2 user test;
> >
> > insert into MEMDB1.tst.Specialty (id_number,
> > specialty)
> >
> > select id_number, specialty from
> > MEMDB2.prod.Specialty;
> >
> > disconnect current;
> >
> >
> >
> > Thanks in advance... I'm open to all recomendations.
> >
> >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
> Messenger
> http://im.yahoo.com <http://im.yahoo.com>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
> <http://people.mn.mediaone.net/scottrmcleod>
>
> ====To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
>
>
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
