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