There is/was a RTVJRNE-using application in
the October 9, 2003 edition of the "Club Tech iSeries Programming
Tips Newsletter." http://systeminetwork.com/node/61261
Google/search for CBX902).
I think it's locked it away behind a 'membership requirement' since I was able to get into it.
Paul E Musselman
"Gad Miron" wrote in message
Need some help with uniquely identifying records in data files that are
to an external (SQL Server) data warehouse.
Only new or updated records are extracted and I need a way to tell which
record is new
(and add it to the DW) and which is existing updated record (in which case
update the existing record in the DW)
The transaction files are about 80 - 100 million records (all in all)
Since I could find a field combination that uniquely identify each records
I tries RRN but apparently some records gets deleted and it is no good.
Any help will be greatly appreciated