RE: TOP 1

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

I prefer Wednesdays.

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Tuesday, June 16, 2015 1:18 PM
To: Midrange Systems Technical Discussion
Subject: Re: TOP 1

yes nelson keep chickening out. I am there every friday, waiting.

On Tue, Jun 16, 2015 at 1:31 PM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

> TOP 1 is not supported on the IBM i, Kickboxer Boy.
>
> RTFM
>
> Paul Nelson
> Cell 708-670-6978
> Office 409-267-4027
> nelsonp@xxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Hoteltravelfundotcom
> Sent: Tuesday, June 16, 2015 12:18 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: TOP 1
>
> its an sql question using the ibm I, genius.  Stop commenting on what you
> know nothing about Nelson. We're tired of your time wasting BS Nelson.
>
> On Tue, Jun 16, 2015 at 7:28 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx>
> wrote:
>
> > Or maybe the Crystal Reports support line.
> >
> > Paul Nelson
> > Cell 708-670-6978
> > Office 409-267-4027
> > nelsonp@xxxxxxxxxxxxx
> >
> >
> > -----Original Message-----
> > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > Charles Wilt
> > Sent: Tuesday, June 16, 2015 9:26 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: TOP 1
> >
> > Or maybe Google...
> >
> > http://lmgtfy.com/?q=fetch+top+db2
> >
> >
> >
> > On Tue, Jun 16, 2015 at 10:14 AM, <paultherrien@xxxxxxxxxxxxxxxxxx>
> wrote:
> > > Time for the manual? ....
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafz.pdf?lan
> > > g=en-us
> > >
> > >
> > > Paul
> > >
> > > -----Original Message-----
> > > From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> > > Hoteltravelfundotcom
> > > Sent: Tuesday, June 16, 2015 9:35 AM
> > > To: Midrange Systems Technical Discussion
> > > Subject: TOP 1
> > >
> > > HI I have one table with all orders info and other table has the
> shipping
> > > info. I only need to 'chain' one row from the shipping table to get
the
> > > ship
> > > via method. But its multi rows so I trued top1 its not compiling. how
> to
> > > read just the first row in sql on the i. I tried top1, topn nothing is
> > > compiling.
> > > (
> > > SELECT TOP 1
> > >     STDTA.pshipll1.phviac
> > >
> > > FROM
> > >     STDTA.pshipll1
> > > WHERE
> > >         "SHPWEIGHT"."IDORD#" = STDTA.pshipll1.phord#
> > > )
> > > --
> > > 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.
> > > --
> > > 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.
> > --
> > 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.
> >
> > --
> > 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.
> --
> 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.
>
> --
> 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.