h**e
发帖数: 410 | 1 Imagine a customer table on an IBM DB2 Linux database and a similar
table on a Microsoft SQL Server database. When I change a customer name
in the DB2 table, I want the DB2 database to automatically update the
same field and the same record in the Microsoft SQL Server database.
It may be that this is not natively possible with DB2 without a high
end DB2 add-on like DB2 DataJoiner. In that case, we may need the DB2
database to automatically start a program that will do the work outside
of the d | n********a
发帖数: 68 | 2 I am not sure about DB2, but in Oracle, I would
write a java program that does the update to
MS SQL Server. Then I load the java program as
stored procedure. A trigger on the table would
call this stored procedure.
I imagine DB2 may allow you to load java program
as stored procedure as well.
【在 h**e 的大作中提到】
: Imagine a customer table on an IBM DB2 Linux database and a similar
: table on a Microsoft SQL Server database. When I change a customer name
: in the DB2 table, I want the DB2 database to automatically update the
: same field and the same record in the Microsoft SQL Server database.
: It may be that this is not natively possible with DB2 without a high
: end DB2 add-on like DB2 DataJoiner. In that case, we may need the DB2
: database to automatically start a program that will do the work outside
: of the d
|
|
