|
| select insert from 2 different database / system |
 |
Wed, 02 Apr 2008 10:14:15 EDT |
Hi <br />
<br />
I have a table A in a system say SYSA, I want to copy selected records into
table B in SYSB. Both are in db2/as400 database. Any pointers on how can we do a
select Insert beteen two different systems / database.<br />
<br />
Thanks<br />
|
| Post Reply
|
| Re: select insert from 2 different database / system |
 |
Wed, 02 Apr 2008 11:07:20 EDT |
If SYSB as SYSA are DB2/schemas, you can do something like this:<br />
<br />
INSERT INTO SYSB.B<br />
SELECT * FROM SYSA.A<br />
WHERE CONDITION<br />
<br />
|
| Post Reply
|
| Re: select insert from 2 different database / system |
 |
Wed, 02 Apr 2008 18:31:50 -050 |
This is not supported with the base DB2 for i5/OS product. You would need to
install DB2 Connect on a UNIX or Windows server and submit the request thru that
server.
yogesht_vijayan@infosys.com wrote:
> Hi <br />
> <br />
> I have a table A in a system say SYSA, I want to copy selected records into
table B in SYSB. Both are in db2/as400 database. Any pointers on how can we do a
select Insert beteen two different systems / database.<br />
> <br />
> Thanks<br />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|