Re: Unique ID

[Alan Campin <alan0307d@xxxxxxxxx>]

I can send code using RTVJRNE also. A few tricks. I thing a RTVJRNE
program might be your best bet.

On Tue, May 1, 2012 at 2:28 PM, Musselman, Paul
<pmusselman@xxxxxxxxxxxxxxxx> wrote:
> 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  (or
> 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
> PaulMmn@xxxxxxxxxxxxxxxxxxxx
>
>
> "Gad Miron"  wrote in message
> news:mailman.17.1335853913.2418.midrange-l@xxxxxxxxxxxx...
>
> Hello guys
>
> Need some help with uniquely identifying records in data files that are
> routinely extracted
> 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
>
> Gad
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.