Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Новый топик    Ответить
 Update MS SQL 2000 on change in IBM Universe  [new]
IgorTaDaDaDa
Member

Откуда: Australia
Сообщений: 88
I have never heard about IBM Universe before I had to integrate my application with IBM Universe (this time).

When I deal with two MS SQL servers I replicate data I need from other vendor DB to my application DB and write triggers on replicated tables which update my application.

If you know Universe's possibilities please offer some options.

I believe there is a better way rather than creating a CSV file on change in Universe and scheduled DTS package to process files and suck it in SQL 2000.


Thks a lot,

Igor
11 май 06, 05:28    [2650380]     Ответить | Цитировать Сообщить модератору
 Re: Update MS SQL 2000 on change in IBM Universe  [new]
warIord
Member

Откуда:
Сообщений: 207
let yor appl. store data into both dbms simultaneously
11 май 06, 16:53    [2653659]     Ответить | Цитировать Сообщить модератору
 Re: Update MS SQL 2000 on change in IBM Universe  [new]
IgorTaDaDaDa
Member

Откуда: Australia
Сообщений: 88
My application needs data from Universe. I do not need to update data in Universe.

For example, Universe maintains data about a resident. My application on MS SQL needs 'resident' table to function. I want every time a new record added or old record updated in Universe this change triggers INSERT/UPDATE/DELETE in MS SQL.

Igor
12 май 06, 04:02    [2655356]     Ответить | Цитировать Сообщить модератору
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Ответить