RE: DB2EUG: Insert Into command in DB2

[Palgrave, Greg]

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.