Re: Embedded SQL For Screen Load

[Charles Wilt <charles.wilt@xxxxxxxxx>]

My advice...

Don't do it.  SQL doesn't really support "Position To", instead it's more
"Search/Subset By"

Lot's of posts over the years detailing the hoops needed in SQL to do a
position to (and provide the exact functionality you have now).  Not really
worth the effort IMO.

On the other hand, it can be very worthwhile to switch from position to to
an SQL based "Search/Subset by".

Charles




On Wed, Dec 14, 2016 at 10:52 AM, (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

> Hi All,
>
> I have to make a change to a pgm written in the 1920's (ok really 1988).
>
> Enter name (partial), setll and read 10 records loading SFL.
>
> User can page back so does setLL again and does READP loading array then
> loads SFL again.
>
> I want to make all this happen using SQL to modernize my skills.
>
> The name is ONLY a starting point, not a match.
>
> Anyone have some code they are willing to share about using SQL in this
> fashion?
>
> Jerry Forss
> Information Technology Team
> WalzCraft
> 608-781-6355 EXT 2530
> jforss@xxxxxxxxxxxxx
>
>
> Subject to Change Notice:
>
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
>
> Confidentiality Notice:
>
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You;
>
> WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
>
> www.walzcraft.com<http://www.walzcraft.com/> Phone... 800-237-1326
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD