RemoteUser
New Member
Hello. We are trying to identify when records within tables upon a remote vendor Progress database has been updated, inserted or deleted. We wish to optimize our data pulls to only include records that have had such an event.
- The vendor states the Progress version is 10.2B.
- We can only access the database utilizing ODBC. We utilize the Progress OpenEdge 10.1C driver.
- This is a remote vender, so we only have read access to the tables...thus no ability to modify the database to do such things as add triggers to capture an insert/update/delete event or record timestamps, etc.
- The majority of the tables do not contain record insert/update timestamps.
- We do have the previously downloaded copy of the tables on our side prior to the download, thus we can do comparisons as we are performing the download...but the tables and rows can be very large and comparing field by field updates is not very optimal. We can save the current ROWID, thus through comparison we can see when rows have been inserted or deleted, but it still not an optimal method.