RE: Noob SQL Help

If you use EXTNAME, how can you tell the compiler to ignore fields that you
might not want to deal with?

Thanks, Jack

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

Jack,

I have no idea what the "most common way" is. Personally I code my own D
specs but I've seen other approaches such as using EXTNAME, etc.

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

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.

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