RE: Noob SQL Help

Thanks Bruce.

Didn't even think of a join. Works great.

What is the most common way of defining the fields rnrule and ruledesc? I
have "D" specs with hardcoded lengths now.

Jack

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bruce Vining
Sent: Monday, April 16, 2012 8:35 PM
To: RPG programming on the IBM i / System i
Subject: Re: Noob SQL Help

Exec SQL Declare C1 cursor for
Select t.rnRule, r.RuleDesc
from shprules t
join Rules r
on r.rnRule = t.rnRule
where t.rnShipper = :svShipper;

On Mon, Apr 16, 2012 at 7:16 PM, Jack Tucky <jacktucky@xxxxxxxxx> wrote:

I'm trying to learn SQLRPG and am struggling with syntax and concepts.



I've been able to do a SELECT of multiple records with a cursor
following examples on the web.



Within the select loop, how can I fetch one row from another file?



This is the beginning of my "loop"



EXEC SQL

Declare C1 Cursor for

Select rnRule from shprules as t

where rnShipper = :svShipper;



how can I use rnRule to fetch a description from table rules?



Thanks in advance.



Jack









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

--
Regards,
Bruce
www.brucevining.com
www.powercl.com
--
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.