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

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Learning something new - love it - thanks, Luis!

Vern

Luis Rodriguez wrote:
> 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.
> >
> >
> >