RE: Embedded SQL For Screen Load

Hello,

I have a template program that does just that. It does position to and allows page up or down. It also have a simple filter option. I re wrote it last year to be pure SQL. It works but, as said, SQL is not very well suited for this.
If you are interested, I can email you privately the source code. But please note that all comments are in French.


Denis Robitaille
Chef de service TI - Solution d'entreprise
Infrastructure et opérations

CASCADES CENTRE DES TECHNOLOGIES
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
Tél : 819 363 6100 Poste :52130
Cell : 819 352 9362



-----Message d'origine-----
De : RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Charles Wilt
Envoyé : 14 décembre 2016 14:39
À : RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Objet : Re: Embedded SQL For Screen Load

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

--
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