RE: Noob SQL Help -- RPG400-L

Modernizing IBM eServer iSeries Application Data Access
(http://publib-b.boulder.ibm.com/abstracts/sg246393.html?Open) Redbook.
Birgitta's one of the co-authors so you know it's gotta be good.

Jerry C. Adams
IBM i Programmer/Analyst
You can observe a lot by watching. - Yogi Berra
--
A&K Wholesale
Murfreesboro, TN
615-867-5070

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of arthur perkins
Sent: Tuesday, April 17, 2012 11:43 AM
To: RPG programming on the IBM i / System i
Subject: Re: Noob SQL Help

Hi all,

Are there any good books on SQLRPG or documentation that is available for
those who want to learn it?

Thanks,

Arthur

________________________________
From: Roger Harman <roger_harman@xxxxxxxxxxx>
To: 'RPG programming on the IBM i / System i' <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, April 17, 2012 12:41 AM
Subject: RE: Noob SQL Help

Why would you care? You can just ignore them. It does predefine the fields
for you which I see as an advantage.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jack Tucky
Sent: Monday, April 16, 2012 7:48 PM
To: 'RPG programming on the IBM i / System i'
Subject: 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.

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

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