I'm not familiar with Sybase, but can you not "simply"
(notice the quotes :) form your SELECT with the entire
before image of the record that was logged? In this
case, you should be able to update the appropriate
entry. This is similar to the way Allbase/Replicate
handles it's data shadowing.
Regards,
Michael L Gueterman
Easy Does It Technologies
email: [log in to unmask]http://Editcorp.nwinfo.net
voice: (509) 946-6179
fax: (509) 946-1170
----------
From: [log in to unmask][SMTP:[log in to unmask]]
Sent: Thursday, May 09, 1996 11:39 AM
To: Editcorp
Subject: IMAGE -> SQL wharehouse(was Re: AIF:PE Question)
The next issue after getting a successful log of all changes in image
will be properly updating them in the SQL world. We are using Netbase
to log Image updates and then we update a SYBASE database. Our
problem occurs when we are updating transactions in a detail set. The
HP Application software was written by another company so I don't know
the code but here is what the logic.
1. read old detail.
2. put new detail with updated field(s).
3. void old transaction.
The problem is after the put there are two records with the same key
values. Then the SQL comes along and voids both transactions.
Image updates 1 record at a time but an SQL update will update all records
that qualify.
I have not resolved this problem yet but I thought I would let you know
about this "Gotcha". If anyone has any wisdom to share on this it would be
appreciated