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
