RE: Noob SQL Help

["Jack Tucky" <jacktucky@xxxxxxxxx>]

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.