I will go ahead and try it out.
Stay well, take care.
El jue, 9 mar 2023 a las 19:40, Vern Hamberg via MIDRANGE-L (<
I googled for "join row with previous row sql" and got this hit -
It mentions lag and lead functions - these are OLAP functions - I
wondered if they exist on the i. And they do -
LAG or LEAD Returns an expression value computed using rows prior to or
following the current row.
These seem to have been added in 7.3 - yes, it is not in 7.2
This looks like just the thing - you do need something that sorts the
results - a windowing thing - it's explained in the manual,
https://www.ibm.com/docs/en/ssw_ibm_i_73/pdf/rbafzpdf.pdf, around page
On 3/9/2023 6:36 PM, Javier Sanchez wrote:
I have always liked the idea of doing something with the previous and/orbut
the next-look-ahead row while you work with the current row. I suspect
that exists. But not with external coding but with some kind of say:
select col1, col2 + PREVIOUS_ROW(col1) from sometable where
somecondition=true/false; // whatever
There may also be a kind of NEXT_ROW(col2) thing.
This is of course a meta-statement of the idea.
You may say I can write a UDF that returns the previous row col2 value,
it would be very difficult because of the nature of your table and your--
It would be nice that this be an intrinsic DB2 functionality. Do we have
Please your comments.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.