I believe what you are looking for is called Federated Database Support.
This is a new feature in DB2 v7.2 from my understanding. Take a look at:
http://www-4.ibm.com/software/data/db2/udb/pdfs/db2v72whatsnew.pdf
Look under DB2 Relational Connect on page 18.
Thanks,
Matthew Stokes
Software Engineer
Internet Technologies
IBM Server Group
Certified: RHCE, MCSE,CLPD(R5), IBM Specialist
"Palgrave, Greg"
<greg.palgrave@unisysw To:
[EMAIL PROTECTED]
est.com.au> cc:
Sent by: Subject: RE: DB2EUG: Insert Into
command in DB2
[EMAIL PROTECTED]
a.best.com
09/06/2001 08:28 PM
Please respond to
db2eug
Hi,
I don't believe you can do it *across databases* unless you either have
another product, such as datajoiner, to allow it OR you have UDB V7.1 and
Db2 Connect 7.1 which I believe will let you do it.
Regards,
Greg Palgrave
Database Administrator
Unisys West
ph: 08 9449 3810
fax: 08 9449 3795
email: [EMAIL PROTECTED]
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). This
information may be subject to legal professional or other privilege or may
otherwise be protected by work product immunity or other legal rules. It
must not be disclosed to any person without our consent. If you are not the
intended recipient, or a person responsible for delivering it to the
intended recipient, you are not authorised to and must not disclose, copy,
distribute, or retain this message or any part of it.
-----Original Message-----
From: LeGrand Decius [mailto:[EMAIL PROTECTED]]
Sent: Friday, 7 September 2001 00:46
To: [EMAIL PROTECTED]
Subject: DB2EUG: Insert Into command in DB2
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.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
