Redian新闻
>
DB2面试题求教,谢谢!
avatar
DB2面试题求教,谢谢!# Database - 数据库
h*e
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
avatar
n*a
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。