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
