Re: SQL Question, Multiple cursors

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Repeat after me....

"If I'm using SQL, the only way to know what order the results will be
returned in is by explicitly specifying an ORDER BY clause."

Charles

On Fri, Jan 8, 2010 at 1:54 PM,  <THarteau@xxxxxxxxxxxxxxxxxx> wrote:
> Hi,
>        I have a declare that gets records from a file where the location
> is like '%200%'.  If none is found, I do another declare, with a different
> cursor name that is not like '%200%'.  It appears that the second declare
> does not start at the beginning. Do I need to reset the file somehow?  For
> example, my locations are G3, G9, P6 & scrap. It did not find any 200
> locations, but the first other location it found was P6.
>
> <===================================================>
>
> Terri Harteau
> Felker Brothers Corporation
> ****************
> "Do not follow where the path may lead. Go instead where there is no path
> and leave a trail."
> Ralph Waldo Emerson
>
> ****************
>
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.