RE: sql equivalent to chain and readpe

Mike,

You could also use an SQL Cursor and do a "Fetch Prior"

That would likely be easier and be equivalent to READPE.

Greg

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Tuesday, October 29, 2019 8:50 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: sql equivalent to chain and readpe

I am converting a rpg program that uses a chain, followed by a readpe to retrieve a value.

I am converting this program to pull the same data from a sql server table using Scott Klements jdbc methods.
I am looking at using the sql lag function, but that does not seem to be what I need.

Data looks like the following

ID TYPE Date Status
21489 RECHECK 20180928 2
21489 REGRADE 20180418 2
21489 REPAIR 20190102 0

Key in file is ID,TYPE,Date

Chain looks for the REPAIR, then does a read prior equal on the ID to get the previous status

Is there a way I can do the same thing using sql ?

Thanks

MIke



NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.