RE: Noob SQL Help

http://www.tylogix.com/Articles/SQL_Tricks_and_Techniques_Book_Review.pdf

________________________________________
From: rpg400-l-bounces@xxxxxxxxxxxx [rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of arthur perkins [atrain01us@xxxxxxxxx]
Sent: Tuesday, April 17, 2012 12:43 PM
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.