Re: Noob SQL Help

[Bruce Vining <bvining@xxxxxxxxxxxxxxx>]

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.