Re: Record by record update with SQL with no matching key.

[Charles Wilt <charles.wilt@xxxxxxxxx>]

ROWNUMBER()

Charles

On Fri, Jan 29, 2010 at 10:05 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx> wrote:
> > Probably have to reorg the "live" member so that the rrns were
> > sequential and in the same range, yes? (the file is quite old and
> > hasn't
> > been re-orged ever to my knowledge)
>
> Hmmm... hadn't considered that.  Probably; I don't know a way to get
> rownumber (as opposed to RRN) from DB2.
>
> Good luck with it; while I haven't done it myself (other than to test the
> sample before I sent) it looks workable.
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> Hard work pays off in the future. Laziness pays off now.
>
>
>
> --
> 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.