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"
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.
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,
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.