Re: SQL Question: Retrieving the last record in a file?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Rich,

You could create a view that gives you the data you need, something like:

CREATE VIEW MyLib/MyViewName as(
  Select  AccNumber, Max(ChkNumber) AS LastCHK
   From   MyLib/MyFile
   Group by AccNumber
)

This will work with RCVF. It is that what you would need?

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Wed, Apr 7, 2010 at 12:46 PM, <Rich_Weislak@xxxxxxxxx> wrote:

> All, I have a SQL question, I need to get the last record with a file by
> Account Number, basically I need to get that last check number used  by
> Company Number, is there a SQL statement that I can use for this, it will
> also be nice if could use it  within a CL program. Any suggestion would be
> nice.
>
> Thanks,
>
>
> Rich Weislak
> Applications Sr. Analyst
>
>
> CONFIDENTIAL NOTICE:
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information.  Any unauthorized review, use, disclosure or distribution is
> prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy all copies of the original message.
>
> EMAIL FILTERING
> Mercy Health Partners (mhsnr.org) blocks email addressed to Mercy Health
> Partners recipients from outside the organization that include attachments
> of commonly known malicious file types (.ZIP,.EXE, .COM, .BAT, etc.).
>
> Emails addressed to Mercy Health Partners recipients from outside the
> organization that include .ZIP or .EXE attachments must contain the word
> "MHP" somewhere in the subject line or they will be blocked.
>
>
>
> CONFIDENTIALITY NOTICE:  This message, including any attachments, is for
> the sole use of the intended recipient(s) and may contain confidential and
> privileged information.  Any unauthorized review, use, disclosure or
> distribution
> is prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy all copies of the original message.
> --
> 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.