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

[CRPence <CRPbottle@xxxxxxxxx>]

  For ROW_NUMBER [aka ROWNUMBER], refer to the SQL OLAP specifications:
http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/db2/rbafzolapexp.htm

  I am not sure how helpful that would be for an UPDATE however. 
It should be able to assist with aforementioned SELECT of CTE, if 
used to generate a new data file as the result set from the desired 
join of ROW_NUMBER & RRN between the original file & the fake-data 
file respectively.

Regards, Chuck

Dennis Lovelady 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 reorganized ever to my knowledge)
> Pete Helgren wrote:
>
> 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.