ODBC link to AS400 db400 file data

C

cww

I am linking to an as400 master file. The file contains ALL historical and
current mast file data rows. The key is the same. Is there an easy way to
retrive the last record for a given key? there is a change date and a change
record for each key, however they are all different. I basicially need the
last changed record for each key without all the history. thanks in advance
 
Top